Date Time Parse Formula

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

Capture.PNG

Capture1.PNG

Capture2.PNG

Date Time

Accepted answers

nagakavyasri

@dougop replace $d with %d:

Screenshot 2024-02-26 121048.png

Datetimeparse.yxmd

All comments

cjaneczko

Its your $d, it should be %d.

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

nagakavyasri

@dougop replace $d with %d:

Screenshot 2024-02-26 121048.png

Datetimeparse.yxmd

dougop

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

thank you all!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280