listbox filter

[Anonymous]

Is there a way to filter dates via the from end search for listbox.

I try the following syntax:

for between 01/01/2018 and 01/01/2019:

>01/01/2018<01/01/2019

but no good,

any idea

?

thanks

[sunny_talwar]

Go through this thread for searching...

Compound Search - demystified

[Anonymous]

I looked at it earlier, but no mention of dates

[YoussefBelloum]

Hi,

to do this, you should use a Date field with this format DD/MM/YYYY and show it like the format shown above.

with this:

=Date(Date_field,'DD MMM YYYY')

Like this, you can search using a Start and an end dates like described above.

PS: your Date_field should have this format DD/MM/YYYY, or DDMMYYYY or whatever format in full numeric value

[sunny_talwar]

Try this

='>01/01/2018<01/01/2019'

or

='>01 Jan 2018<01 Jan 2019'

[Anonymous]

did not work

[Anonymous]

did not work

[sunny_talwar]

Is your date field format DD MMM YYYY or are you just displaying it like this but the actual format is something else?

[Anonymous]

SET DateFormat='DD MMM YYYY';

[sunny_talwar · Accepted solution]

And how is the date created?

Date(Dates) as Dates?