Set date range picker to default

[kdaniels-obrien]

Hi, 

I am using the Date Range Picker in my sheets.  I would like to set the date range picker to default to today's date...  But I would also like to allow users to select different days if they chose to. 

So I expect that when the user opens the sheet, all of the data is filtered to today's data.  The user can also select another day's worth of data by selecting new days in the date range picker. 

Right now, I have set vDefaultDate in my load script to today(): 

Let vDefaultDate=today();

In the sheet edit mode, I set the date field to =$(vDefaultDate) but it doesn't seem to apply the filter and I can't select another set of days... Can someone help me with this problem?  Thanks in advance! 

[lorenzoconforti · Accepted solution]

In your Date Picker object under Field, enable Advanced Setup then set Start date and End date to:

=vDefaultDate

It will default to the date you are defining in the script and will allow the user to change it

[kdaniels-obrien · Accepted solution]

Nice, that worked! Thank you

[lorenzoconforti · Accepted solution]

Glad it worked

Please set the thread as solved