convert string to date format

[bh1789]

can someone assist, I need to convert string "Jul'23" to "2023/07/01"

I am using DateTime Parse tool but my output is [null]

[cjaneczko]

You can use the following formula where [Field1] is the field that contains "Jul'23". 

datetimeformat(DateTimeParse([Field1],"%h'%Y"),'%Y/%d/%m')

[JosephSerpis · Accepted solution]

Hi @bh1789 you will need to use Mon'yy in the Datetime tool to get a output based on the format of your date.

I would also recommend you have a look at the specifers Alteryx use for dateformats you can find them here.