Does anyone know how to use the Date function when querying?

I've tried entering the date manually and through the calendar function but with no avail.

??????????????

Thank-you

If so,

then for current date, query operand would be :-

date()

or for a specific date other than current :-

date(YYYY,MM,DD)

e.g. date(2002,07,07) for yesterday

Put your operator and in value field push Ctrl + Shift + Z
It will display calendar if it is a date field.

Also works with enum fields, displaying possible values in a list box. :cool: