Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering date using filter tool - not working

Naga
8 - Asteroid

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'

 

 

1 REPLY 1
RolandSchubert
16 - Nebula
16 - Nebula

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

Labels
Top Solution Authors