Page 1 of 1

filter of a Date field

Posted: Mon Jul 04, 2022 8:53 am
by mhanu
Hi. i have a date column in this format: 25/05/2021. i have set the variable as Ordinal, text

i am trying to apply a filter like this:
`Date`<='25/05/2021' in order to exclude all records newer than 25/05/2021

the filter does not work properly. is something wrong in date format or syntax?
Thank you

Re: filter of a Date field

Posted: Mon Jul 04, 2022 10:47 am
by mhanu
IA HAVE SOLVED BY CAHNGING DATE FORMAT

2021-05-25