community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Date Conversion/ Date Formatting

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.

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

Meteor

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

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.

Alteryx Partner

Hello,

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

Labels