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.
Solved! Go to Solution.
use formula tool to combine both columns
in second formula use datetimeparse("%B-%Y)
@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: