UNIX Time conversion

[rmartinez4]

Hi I have a Json file that I pull in data with field that contains a unix time of 1678818797. Is possible to assist on how to convert this into Datetime and then to a date.

Thank You,

[BS_THE_ANALYST]

@rmartinez4 This is calculated via UTC time zone by the way:

Step1:

Step 2: turn it just to a date

Workflow attached.

All the best,
BS

[DataNath]

Hey @rmartinez4, whenever we have a UNIX field, the way to convert this to a DateTime is to add that number of seconds to the 1st of January, 1970. Using DateTimeAdd to do that in Alteryx, we get the full timestamp as seen in the [DateTime] field. In order to have it as Date only, we just need to change the Data Type in the drop down of the Formula: