2 Replies Latest reply on Nov 15, 2012 9:06 AM by Li-Kim Lee

    US vs. UK date formats keep alternating when publishing to server

    Li-Kim Lee
    Li-Kim Lee Nov 12, 2012 4:51 AM

      Hi, I am based in the UK and experiencing problems with the display of dates in a workbook. I use an EXCEL extract of data where the 'Time Period' is in a US format of mm/dd/yyyy. Tableau Desktop shows the 'Time Period' dates wrongly and interchanges the month and day fields, probably since I am based in the UK. So I solve the issue by using a calculated dimension to change the 'Time Period' to a UK 'Date' dimension. And the data looks fine in my workbook. Examples of both the US 'Time Period' and UK calculated 'Date' dimensions are shown below.

       

      DateTime Period
      29/10/201210/29/2012
      30/10/201210/30/2012
      31/10/201210/31/2012
      01/11/201211/01/2012
      02/11/201211/02/2012
      03/11/201211/03/2012

       

      However, when I publish the workbook to our server which is US-based, the dates then revert to another format entirely, probably because the US Tableau server is recognising the UK workbook dates as US dates again. Is there a way round this via settings or config of the data or Tableau Desktop?

       

      Thanks.