This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.