Convert Month and Year columns to a date type

[marychetti11]

I have 2 columns containing Months and Years. I am able to get Years to read as a date but I can't figure out how to get the Month to read as a month to combine into 1 column.

Month	Year
String	date
text	date
February	2023
May	2023
November	2023

[Turribeach]

Add a step a in prepare recipe and add a formula processor. Then use this formula:

asDate(concat(Year, '-' , Month, '-01'), 'yyyy-MMM-dd')

 and you will get a full date data type.