Select in field - using variable

[arsenal1983]

Hi,

I would like to have a button that will filtr my details data. The filter should be set on the column DATE and I want to see only the docs with DATE, before the variable date (vDATE) set in the callendar object.

Any suggestions?

LL

[sunny_talwar · Accepted solution]

May be use this as search string:

='<=' & Date(vDATE, 'YourDateFieldFormat')

[arsenal1983]

THX, got it.

[maxgro]

see attachment