Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have used the date field as Sold date(m/d/yyyy)
I need my list box to be select by default dynamically last 3 days.
Ex: for today my list box should select 3/13/2017,3/12/2017 and 3/11/2017 if num of day increases it will rollback.
Thanks..
If this is what you expect, please see the attached, just use one 'select in field' with
='>='&MonthStart(Today()) & '<=' & Date(Today()-1)
How do you want this to be triggered? On document open?
If so I would use a field trigger and just toggle select today(), today()-1 etc
Please see attached example (settings> document properties > triggers> on open)
Thanks..
If i need to show the dates from month start to today()-1 how to get this.
Thanks..
Ok so what is your actual requirement as it seems different from your original post?
If I opened the dashboard today, you would expect it to select from 1st March to 13th March?
If this is what you expect, please see the attached, just use one 'select in field' with
='>='&MonthStart(Today()) & '<=' & Date(Today()-1)
Yes exactly..But i need selections at sheet level and it won't disturb other sheets.
Thanks..