Filtering date using filter tool - not working

[Naga]

Hi Team,

Need a quick help.

I have to filter data based on 2 criteria of which one is a date field, which is of format 7/1/2019 (m/d/yyyy). When I do the filter as below I am not getting the expected result. I have also changed the alteryyx datatype to date.

[TERMINATION DATE]>='7/1/2019'

[RolandSchubert · Accepted solution]

Hi @Naga ,

you could try:

DateTimeParse([TERMINATION DATE], '%m/%d/%Y') >= DateTimeParse('7/1/2019', '%m/%d/%Y')

Both filter criteria and value are converted to date and compared after conversion. Hope this is helpful.

Best,

Roland