List box default MTD date selection

[nareshthavidishetty]

Hi,

I'm having the order date with date range starts from 1/01/2016 to till date.

I need to set the order date in list box by default Month start to till date.

Thanks...

[sunny_talwar]

Not sure I understand, can you explain using an example?

[nareshthavidishetty]

Hi,

By default my filter should select the date from montstart to till date as below image.

Thanks..

[miguelbraga]

This video will save your life

https://www.youtube.com/watch?v=UTDyO68BYL8

Best regards,

D.A. MB

[sunny_talwar]

You can add a trigger to your field, but it can start to get very messy. if you are okay with that, then you check this out

Selecting Arbitrary Date Ranges‌

Lower limit will always me the Min({1}Date)

[nareshthavidishetty]

Hi ,

It's not the requirement ..it showing the to get date range.

My requirement is when i open the sheet my date filter should be Month start to till date.

Thanks..

[miguelbraga]

See the video you'll see that you can make two variables, right?

If so, then you can apply a trigger in sheet to apply the changes in to the varibles that will make your selection in range

What I am missing?

Best regards,

D.A. MB

[sunny_talwar · Accepted solution]

Check out the attached