Date Help

[derekthomas4]

How do I convert a string "033124" to be "2024-03"?

Thank you in advance!

[DataNath]

Hey @derekthomas4, there's a few ways to do this but I personally like the Formula tool option - the following expression ought to work:

DateTimeFormat(DateTimeParse([Input],'%m%d%y'),'%Y-%m')

[Matt_D]

Hi @derekthomas4 

Left(DateTimeParse([YOUR_VALUE], "%m%d%y"), 7) assuming I'm looking at 03 (month) 31 (day) 24 (year)?

Matt

[derekthomas4]

Thank you!!!