I want to convert Y21 (string) to 2021, Y17 to 2017 format in alteryx, can anyone please guide me on this?
Solved! Go to 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.
Awesome it worked bro thank you
done