Convert Epoch Time to Date Time

[Sandy381]

Hi,

I'm having a field with EPOCH times in string format in Enhanced Table

So I'm trying to convert EPOCH values to Date time in Enhanced Table.

First , I create a calculated column with EPOCH values in Number values.

Then, I try to convert the EPOCH to Date time in my format DD-MMM-YYYY format.

But, I'm not able to convert using parseDate

Below Screenshot of the issue

Pls Help.

[fbaligand]

First, you don't need to use parseDate function, given that it takes a ISO-8601 formatted date and converts it to the number of milliseconds since Epoch.
Then, expected value for a "Date" formatted column is the number of milliseconds since Epoch.
It seems that your "Execution Date" is in seconds.
So I invite you to use this formula: col2 * 1000

[Sandy381]

Yep, That was the issue.

The time was in seconds, now I multiplied by 1000 & converted to millisec and I'm able to see in Time Date format!.

Thanks!

[fbaligand]

Great!