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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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.

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