1 Reply Latest reply on Sep 26, 2014 1:20 PM by Joe Oppelt

    Date time conversion issue

    Deepak Deopura

      Hi

      I have data in excel file which contain datetime field with Time zone . Thhis contain "T" and "Z" character because of that I am not able to convert it to datetime field.  Following is sample data.

      2014-09-18T07:56:03.145Z2014-09-18T07:56:03.145Z

       

      Any point on this issue will be very helpful.

       

      Thanks

      Deepak Deopura

        • 1. Re: Date time conversion issue
          Joe Oppelt

          I am going to assume you have to have the T or Z in there for some other purpose (else you would have simply removed it already.)

           

          I would either:

           

          add another column to the excel file and replicate the date/time without the T or Z,

           

          or

           

          Do a calc field in Tableau that does string manipulation to replace "Z" with " " or replace "T" with " ".  (Or some other appropriate treatment of the Ts and Zs.)  Be sure to convert the manipulated string into data format.