ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Ignore field conversion error DateTimeParse

Chirag_KRCPL
8 - Asteroid

I am using below formula to get dates that are in different format:  
Chirag_KRCPL_0-1662378511114.png
Although I am getting the expected results ie the Date column as shown in above snip, but along with this I am also getting below error:

Chirag_KRCPL_1-1662378964155.png

Requirement: The field conversion error is defeating the eventual purpose of my workflow and hence I want to Ignore/kill it. So please suggest a solution to my problem ( I don't want to use delimit since string is having different pattern)

Regards,  

Chirag

1 REPLY 1
binu_acs
21 - Polaris

@Chirag_KRCPL One way of doing this by checking the first two digit of the date is > 12 then use the format %d/%m/%Y else use %m/%d/%Y

 

binuacs_0-1662381259240.png

 

Labels
Top Solution Authors