Filtering on the current date

You can filter to keep only records with the current date using meta information. No need to keep amending the current date every day in the filter.

filter-on-today.transform (2.3 KB)

dates.csv (94 Bytes)

1 Like

What about filtering on a certain date? I run a report every Sunday and the data needs to grab all information that happened on any day in the last 7 days. So the script would be =today minus 7 days.

Actually it would be =any data that occurred on a day between 7 days ago and today

Once you have got today date you can use Calculate to calculate the difference between it and another date.

Then use Filter to keep only the rows you want.