Forum Discussion

smithmc3's avatar
smithmc3
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Query Editor date filtering

I am trying to filter a column based on date and I only care about the records that are equal to or less than two years old  
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi smithmc3,

     

    Please refer to the steps below.

    1. Select any date when filter data and click OK button.
    2. Change the date #datetime(2017, 3, 16, 0, 0, 0) to Date.AddDays(DateTime.LocalNow(),-730))

     

    Regards,

    Charlie Liao

     

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi smithmc3,

 

Please refer to the steps below.

  1. Select any date when filter data and click OK button.
  2. Change the date #datetime(2017, 3, 16, 0, 0, 0) to Date.AddDays(DateTime.LocalNow(),-730))

 

Regards,

Charlie Liao

 

smithmc3's avatar
smithmc3
Icon for Advocate I rankAdvocate I
9 years ago

So I made the change {= Table.SelectRows(#"Changed Type", each [Transcript Completion Date] <= Date.AddDays(DateTime.LocalNow(), -730))}

 

Then I noticed it was only showing 52 rows instead of 999+.  Looked at some of the dates and it was only showing those more than two years old ... changed "<="  to ">=" and we where back in business.  Thanks for the help!