Date range selection help

[Anonymous]

In the attached file I am trying to get the date selections to effect the table and show a to - from date in the current selections box. I seem to have everything in place, but it still does not work. Any help on this will be greatly appreciated.

[ashfaq_haseeb]

Hi,

Check if this helped.

Regards

aSHFAQ

[Anonymous]

Ashfaq,

That is it. How did you make it work?

[ashfaq_haseeb · Accepted solution]

Hi,

Your date was not formatted properly.

Correct Expression

='>=' & Date(vPlaceStart, 'MM/DD/YYYY') & '<=' & Date(vPlaceEnd,'MM/DD/YYYY')

and remove = sign from field.

look at attached image.

Regards

ASHFAQ

[israrkhan]

See this video too... will show you how to select date ranges...

Selecting Arbitrary Date Ranges

[Anonymous]

Awesome, thank you for your help!