HELP NEEDED - Transforming Dates (Text to MM/DD/YYYY Format)

[Imzadi_1701]

Hello, Community. 

I've tried researching a solution to my problem, but my efforts have been futile.  I need to transform the text string date in the first column to an actual date in a new column in MM/DD/YYYY format, but I can't seem to figure it out.  I've tried a few different DateTime functions, including the DateTimeParse(). Any and all help is much appreciated. Thanks in advance!

Current Format (as Text)	Desired Format (as Date)
MAY-23	05/01/2023
DEC-22	12/01/2022
APR-24	04/01/2024

** NOTE: The DD will always be 01 for the first of each month.

[alexnajm · Accepted solution]

Dates in Alteryx can only be stored in YYYY-MM-DD format - any other format will be a string!

Here are the two options you have - store it as a string with the format you want, or store it as a date with the YYYY-MM-DD format. Both options included int he workflow below.

[Imzadi_1701]

That worked perfectly and was much easier than what I was making it out to be.  Thank you!