I have a series of tables that I refer to through-out the day, and I only look at one row which is the entry with the latest date and time.
Currently I set the latest date with an interactive filter and a button for today and a button for yesterday, in case the latest entry was yesterday.
So there’s some guesswork involved, and also if I’ve made more than one entry today, I get more than one row for the results.
Is there a way I can create a button that will set the control value of the interactive filter to the latest date and time?
I’ve experimented with max() and Sort.Date() but have not been able to make it work.
Many thanks for any help you can offer!
FWIW, it seems like First and Last would be good options for “Select a date range” on an interactive filter for a date field?