Date Format

[sharmilaj]

Hi all,

I have my month and year in different columns. Need to combine the both and form date in MMM-YY format. 

Month	Year
1	2023

I need the output to be Jan-23. 

Kindly help with the Alteryx flow. 

Thanks in advance. 

[BRRLL99]

use formula tool to combine both columns

in second formula use datetimeparse("%B-%Y)

[DataNath · Accepted solution]

@sharmilaj bunch of ways to do this but here's one - if your [Month] and [Year] columns are already strings then there's no need to wrap the fields in the ToString() function: