14 Replies Latest reply on Feb 20, 2018 10:08 PM by Peter Timbol

    Converting an integer to datetime

    . superpoke

      How do I convert an integer, which represents the seconds since epoch in the GMT timezone, to a datetime field in Tableau? I have tried the following:

       

      - Tried to create a calculated field and used the datetime() function to convert the integer. I do not think this function expects and integer, so it just returns NULL

      - Tried to use the drop down Change Data Type -> Date & Time. This also returns NULL.

       

      I am looking for a client side (Tableau solution). It is not possible to create a view in the database or modify the data type for the column in the database.

       

      Is this possible?