Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 |
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.