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'
Solved! Go to 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