String to Date Conversion

[Lizbhernan]

Hello,

I am trying to convert MM.YYYY to a date and I am having a hard time. Can someone help?

Currently my data looks like this 12.2024 and I need it to convert to 12.1.2024. I tried using the DateTime tool but I am unable to get it work.

I have attached my workflow in case someone is able to assist me.

TIA

[alexnajm · Accepted solution]

Since you don't have a day there, a Formula will be better - try this:DateTimeParse(Left([3], 2)+"01"+Right([3], 4),"%m%d%Y")

[Lizbhernan]

Hi Alex, TYSM! This worked 😊