string date

[rbanola1]

I want to convert Y21 (string) to 2021, Y17 to 2017 format in alteryx, can anyone please guide me on this?

[DataNath · Accepted solution]

Hey @rbanola1, there's a bunch of ways you could do this. One would be a Formula tool with the following expression:

DateTimeYear(DateTimeParse([Incoming],'Y%y'))

Just replace [Incoming] with whatever your field is called.

[rbanola1]

Awesome it worked bro thank you

[caltang]

Hi @rbanola1 - could you help mark @DataNath's solution as accepted? This helps close the post and helps others to find the answer faster + know that it works.

Thanks! 😁

[rbanola1]

done