Date Conversion

[timothysmith_NYFRB]

I have an Alteryx date (2022-11-01), how do I convert that to November 1, 2022

[binuacs]

@timothysmith_NYFRB One way of doing this 

[gautiergodard]

Agree with @binuacs .

Here is another way to do the same thing using the date time convert tool from the Parse Pallet:

[grazitti_sapna · Accepted solution]

@timothysmith_NYFRB , Please find the solution. You can easily do it by converting datetime to string and give it the required format.

[DenisZ]

You can use the formula tool with the formula 

DateTimeFormat([Date],"%B, %Y")

Hope it helps.  

[Sebastiaandb · Accepted solution]

Hi @timothysmith_NYFRB ,

Here is a solution without the leading zero for the day of the month.

DateTimeFormat([Field1],"%B %e, %Y")

See the attached workflow as well :-)

Greetings,

Seb