Date Conversion/ Date Formatting

[Swadekar]

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

[derekbelyea · Accepted solution]

This should point you in the right direction.

[Swadekar]

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

[htalteryx]

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

[derekbelyea]

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

The DateTime tool handles this easily.

[Kirti1]

Hello,

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