To convert date from 2019-05-01 to May-19

[Nikhil8087]

Whenever I import the .xlsx file to a Alteryx flow, date value changes from May-19 to 2019-05-01. But I want 'May-19' as it is. Is there any way to do that? Also, there are some values in 'May 2019' format but I want to convert them into 'May-19' format. How can I do that? I have attached an excel file containing list of Month-Yr and date combinations which are needed to be converted to the type under 'To' column. 

[LordNeilLord · Accepted solution]

Hey @Nikhil8087 

Check out this page and bookmark it!

It tells you everything you need to know about datetime functions in Alteryx..

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

[JosephSerpis]

Hi @Nikhil8087 

                          I created a sample workflow that will convert your dates. It follows the same logic as described by @LordNeilLord . I also added in some logic to handle the different date formats so that all your dates are converted to the desired date format.  

[meads]

Hi,

You can import the Excel file as is and use the date parse function to ensure it is correct. Please see below screenshots. Be careful using these dates though, because it Defaults to the 1st of the month if no Day is specified, this may cause confusing results, or may be what you need. It depends, just a word of caution. Hope this helps.

Additionally to get the 'Mon-YY' Format try using a text to columns split to 2 rows at ' '(Space) this will return all combinations not matching the Mon-YY format, you can then combine these fields in a formula and overwrite the original column so they have uniform formatting.

[echuong]

I think this is more what you're looking for. Let me know if thiat works for you