Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go through this thread for searching...
I looked at it earlier, but no mention of dates
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
Try this
='>01/01/2018<01/01/2019'
or
='>01 Jan 2018<01 Jan 2019'
did not work
did not work
Is your date field format DD MMM YYYY or are you just displaying it like this but the actual format is something else?
SET DateFormat='DD MMM YYYY';
And how is the date created?
Date(Dates) as Dates?