Dynamic Date Filters

Question

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 Answer

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 : )