last 28 days on query editor

[MP_123]

hi,

is someone know how to filter rows in query editor (#filtered rows) on the last 28 days?

thanks

[Greg_Deckler]

You can do something like:

DateTime.From([Date]) - DateTime.LocalNow()

This will return a duration and you can check how many days are in there and set the filter on import to only be greater than so many days.

[SabineOussi · Accepted solution]

Hi MP_123,

Go to the Query Editor, select the column in question. When filtering, choose Date Filters, then "In the Previous..." and specify how many days you want to filter on.

This can also be applied to all date/time fields not only days.

Note that your column must be of data type Date in order to do the correct filtering.

Hope this helps!