month to date

Hi all:

I have a column of just months...string, and month is identified in full.....'January', 'February'....'October'....

I'd like to convert them to dates, so ideally, January would be 2022-01-01, and February would be 2022-02-01, and October would be 2022-10-01.

Anyone know how to do this?

-prpatel

Date Time

Accepted answers

I have uploaded a sample WF that converts a month into a date.

Hope this helps. If it does, please like the post and mark it as a solution.

Attached is one way of doing this:

One way of doing this

INPUT

OUTPUT

month to date.yxmd

I have uploaded a sample WF that converts a month into a date.

Hope this helps. If it does, please like the post and mark it as a solution.

Attached is one way of doing this:

I could not get your file to open. ☹️

@prpatel it is probably due to different versions of Alteryx 😥

Your solution works as well. 👍