Loading
Help Agent Performance DegradationRead More

Dates Display in Unix Time Instead of Date or Datetime

Publish Date: Feb 26, 2026
Description
A datetime field is displayed as a number or string in Tableau.

Cause

The datetime field uses the Unix time format. Tableau Desktop does not automatically convert this time format into a date or datetime format.
Resolution

To convert the field to UTC time, use the following calculation:

DATEADD('second', [Unix time field], #1970-01-01#)


To convert the field in Unix time to a different time zone, use the following calculation:

DATEADD('minute', INT([Unix time field]/60 + <UTC offset in minutes>), #1970-01-01#)


For example, to convert the field in Unix time to India Standard Time (IST), use the following calculation:

DATEADD('minute', INT([Unix time field]/60 + 330), #1970-01-01#)


Note: Both the above options assume that the Unix time field is in seconds. If the field is in milliseconds, convert it by dividing the field by 1000.
Knowledge Article Number

001473641

 
Loading
Salesforce Help | Article