Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Date Conversion/ Date Formatting

Highlighted
Atom

Hello Guys, 

 

I have been struggling to convert a date column which is in 'yy.dd.mm' format to any of the standard date formats(mm/dd/yy , mm.dd.yyyy etc), I have tried a few suggested solutions on other discussion threads, viz. DateTime tool and DateTimeFormat function in the formula tool. 

Issues:

1. In the DateTime tool when I try to convert '16.14.12'  using the custom format the newOutputColumn displays 2016-01-12  00:14:00.  and

2. using DateTimeFormat function returns a null value in the newOutputColumn 

 

I just want to convert to convert the 'yy.dd.mm' format date into a regular mm/dd/yyyy or mm/dd/yy or dd-mmm-yyyy format so that Tableau can recognize the date and year. 

 

Regards,

Soham

Alteryx Partner

 

This should point you in the right direction.

Highlighted
Atom

Perfect, exactly what I wanted!

Just changed left([Date],4) to left([Date],2) as my year is just 'yy' and it worked. 

 

Thanks a lot! 

Soham

Highlighted
Meteor

how do I convert 31-Dec-2018 to 12/31/2018 using the formula tool?

Highlighted
Alteryx Partner

This requires converting your text string to a date and then the date to a new text string.

The DateTime tool handles this easily.

Highlighted
Alteryx Partner

Hello,

Tried using datetime tool instead of formula tool to get required results. Please find attached workflow

Labels