Hi Garth! You could do this either by using a relative date filter or by filtering on the top 1 by MAX(Date).
To use a relative date filter, drag your date to the filters and pick "Relative date". Then choose "Today".
To filter using the top 1 date, drag your date to the filters and pick "Individual Dates". Then, go to the "Top" tab and set it up like this:
Thanks for this David but it doesn't give me the results I'm looking for.
Filtering on the relative date of today only gives me entries with the date of today (one day). Not entries including today and all the future days.
Filtering on the top 1 max. Gives similar results.
Any more ideas?
Oh, I see what you mean! In that case, on the second option, clear the Top filter and then go to Condition. In the formula editor there, put in something like this:
[Date Field] >= TODAY()
This is great! i'm kind of looking to do something similar.
I need to filter my data so that is shows all the data for the previous day. However, on Monday it will need to be Friday not Sunday.
It needs to exclude weekends, so any dates that fall on the weekend should be reported as the Friday before.
Do you know how i could implement this, building upon the above?