Date format to be read from 01/01/2021 to "JAN" .

[Inactive User]

Hi There,

I wanted to convert date string form 01/01/2021 to "JAN" only using formula's. kindly advice.

Thanks in advance. 

Regards

Guru

[Emil_Kos]

Hi @Inactive User,

I am not sure which one was a month and which one was the day:

If it will not work other positions you need to swap month with day in the formula below:

DateTimeParse([Date],'%d/%m/%y')

There is a great source of information about how to parse date-time using Alteryx:

https://help.alteryx.com/current/designer/datetime-functions

[Inactive User]

Hello - 
I think it will not work in my case - am looking for the output read "mmm" (i.e. first 3 letters of the month) from date field - for example - today's date 02/27/2021 to be read only as "FEB". any thoughts on how we can use this logic in formula. 

Thanks,

Guru

[Emil_Kos · Accepted solution]

Hi @Inactive User,

my workflow is first changing the date you have provided to a date format. The last thing what it is doing is creating a column with name only as Jan for example.

Did you had a chance to try this workflow?

[Inactive User]

Yes - its working fine. thanks