Forum Discussion
smithmc3
Advocate I
Advocate IQuery 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
Hi smithmc3,
Please refer to the steps below.
- Select any date when filter data and click OK button.
- Change the date #datetime(2017, 3, 16, 0, 0, 0) to Date.AddDays(DateTime.LocalNow(),-730))
Regards,
Charlie Liao
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi smithmc3,
Please refer to the steps below.
- Select any date when filter data and click OK button.
- Change the date #datetime(2017, 3, 16, 0, 0, 0) to Date.AddDays(DateTime.LocalNow(),-730))
Regards,
Charlie Liao
hxkresl
Advocate III
Advocate IIIv-caliao-msft Followed this post and implemented solution but getting error "we cannot apply < operator to types date and datetimezone". Which type do I need to use?
First make filter, choose any date
Next open query editor and find code for filter
Next I replace with your code snippet
I get this error
