List box selection

[nareshthavidishetty]

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..

[adamdavi3s]

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)

[nareshthavidishetty]

Thanks..

If i need to show the dates from  month start to today()-1 how to get this.

Thanks..

[adamdavi3s]

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?

[adamdavi3s · Accepted solution]

If this is what you expect, please see the attached, just use one 'select in field' with

='>='&MonthStart(Today()) & '<=' & Date(Today()-1)

[nareshthavidishetty]

Yes exactly..But i need selections at sheet level and it won't disturb other sheets.

Thanks..