Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to create an action that will enable the sheet to open with a date field selection for all dates in the last seven days. I can get it to select one date with = today()-1 for example, but I need to select multiple dates automatically on open. Have tried = today()-1&today()-2..... but that doesn't work. Any help would be appreciated.
Thanks
Hi
Its pretty much easier to do with bookmark
First make selections in the date fields based on the below expression, make sure that you press enter key
=DateField>=Today()-7
Where DateField is your date field name.
Select other date fields as well, then create a bookmark with the final selections.
Please refer attached QVF for reference.