Convert Month to date

[Stuart_C]

Hi,

I have a column with the full name of the month.  I created a column named "Date".  I'd like to have the the Date column show the date as the first of the month and current year.  How could I do this?

Current Data:

Current Data:			Output:
Month	Date		Month	Date
January			January	2020-01-01
February			February	2020-02-01
March			March	2020-03-01
April			April	2020-04-01
May			May	2020-05-01
June			June	2020-06-01
July			July	2020-07-01
August			August	2020-08-01
September			September	2020-09-01
October			October	2020-10-01
November			November	2020-11-01
December			December	2020-12-01

Thank you,

- Stuart

[JosephSerpis · Accepted solution]

I mocked up a workflow let me know what you think?

[Stuart_C]

This is exactly what I wanted.  Thank you @JosephSerpis !