Alteryx Designer Desktop Discussions

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

Date Time Parse Formula

dougop
7 - Meteor

Hello All,

 

Trying to get the date time parse formula to convert some date strings coming into my workflow but I am continually getting "Null" outputs and I am not sure why.  Have attached a couple screenshots with the format the date is coming in and how I currently have the language in the formula as well as the output column.  Any help is appreciated!

 

thanks 

 

Doug

3 REPLIES 3
cjaneczko
13 - Pulsar

Its your $d, it should be %d.

 

 

DateTimeParse([ExamStart],'%m/%d/%y %I:%M %p')

 

nagakavyasri
12 - Quasar

@dougop replace $d with %d:

 

Screenshot 2024-02-26 121048.png

 

 

dougop
7 - Meteor

oh wow that's embarrassing - I can't believe I missed that

 

thank you all!

Labels
Top Solution Authors