month to date

[prpatel]

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

[Felipe_Ribeir0]

Hi @prpatel 

One way of doing this

INPUT

OUTPUT

[PanPP · Accepted solution]

Hi @prpatel 

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.

[DavidSkaife · Accepted solution]

Hi @prpatel 

Attached is one way of doing this:

[prpatel]

@Felipe_Ribeir0 ,

I could not get your file to open. ☹️

[Felipe_Ribeir0]

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

[prpatel]

@DavidSkaife 

Your solution works as well.  👍