Power Query - Check if date was within the past year RRS feed

  • Question

  • Hello,

    I am developing a master record for a non-for-profit. I am querying a CSV file and I need to see if someone's intake date was withing the past year and return "Eligible" if it was. I can get query to pull today's date and time based off of the system, but I am having a hard time converting that to one year ago and checking if the start date is greater or less then one year ago. Do you have any suggestions? 


    Monday, April 3, 2017 3:48 PM


All replies