Filtering on the current date

Share
1

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.

current-date
current-date1141×728 178 KB

filter-on-today.transform (2.3 KB)

dates.csv (94 Bytes)

1 Like
2

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.

3

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

4

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

calc
calc537×631 129 KB

Then use Filter to keep only the rows you want.