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
Solved! Go to Solution.
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
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
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?
Yes - its working fine. thanks