2 Replies Latest reply on Oct 18, 2018 7:12 AM by Contracts AKDN

    Date format from excel data source problem

    Contracts AKDN

      Dear All,

      I am using an excel data source that come from an extract form a 3rd party software

       

      The date in Excel has a format 01/10/70 for example (See attachement).
      But in tableau it is interpreted as 01/10/2070 (See attachement).

       

      How could I fix it without having to update the excel file as this extract will run every weeks and I want to reduce at maximum human actions.

       

      Thank you,

       

       

       

      Vincent