How do I use DateParse to get MM/DD/YY format?

Question

In my workbook, Tableau automatically converts the date field to string in YYYY-DD-MM format, but I need to convert it to MM/DD/YY format. I tried doing this with the Dateparse function in a calculated field, but it returns null.

Thanks for any solutions or tips!

Hideaki Shiihara · Accepted Answer

Hi, @N olan Miller What would you like to use after changing the date format? Would you like to output it as CSV?  How about using a formula to change the order of the year, month, and day while keeping the text?   ﻿

Nolan Miller · Answer

That does the trick, thanks! Yes, I am first concatenating the string date field with another field to read "x week period ending MM/DD/YY", with the final output being CSV used in Excel pivot tables. I am surprised that Tableau does not have built in date formatting options in Prep--it would save needing the workaround formula.

How do I use DateParse to get MM/DD/YY format?

Tableau Prep

Aprendizagem relacionada

Mais ajuda