Dynamic Date Filters

[HannahSwain7]

Hi all,

Is there a way to have a filter which only brings back rows of data which are within the last 30 days please?

Thank you,

Hannah

[atcodedog05 · Accepted solution]

Hi @HannahSwain7 

You can use filter like below on date field to keep only current month data.

For 30days back you can use below in filter

Datetimediff(Datetimetoday(),[date],"days")<=30

Hope this helps : )