Tableau server 10.1.3.
I am exporting data from tableau in a CSV file using tabcmd export command . In the exported workbook i have two date time columns with the format
mm/dd/yyyy hh24:mm:ss (03/28/2017 22:45:12)
But when the csv is generated the file format is changed to
mm/dd/yyyy hh:mm:ss AMPM (03/28/2017 10:45:12 PM) which is an unreadable format for the tool to which we are supplying this data.
I am able to see the correct format when i view the CSV file using MS Excel.
Please help in this case.i want the date in mm/dd/yyyy hh24:mm:ss (03/28/2017 22:45:12) format.
Thanks in advance
I tried out a test and got the same results as you did. But a workaround is to create a calculated field in the exact notation that you need. This seems to work.
And then when you export, the calculation will have what you need.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...