Expression for all dates less than 'TODAY'

[jglenn87]

Hello,

I am trying to create a button for a sheet to filter for all dates less than TODAY using the 'TODAY' Expression, but have not been successful so far. Any ideas?

[TimvB]

You can add a flag field to your mastercalendar in the script that flags all dates that are earlier than today, today and in the future, for example:

If(DateField < Today(), 'Past', If(DateField = Today(), 'Today', 'Future')) as DateSortFlag

Add a filter object with the dimension field DateSortFlag to the sheet and users are able to select dates from the past in one click.

Hope it helps!