Convert epoch to human-readable date

[EN6924]

My data is like below -

Checked from https://www.epochconverter.com/

Need to add GMT+5:30

How should I convert it?

[mbarone]

We would first need to know what epoch time is.  I've never heard of it and haven't researched it.  What does it mean and what to the digits represent?

[atcodedog05]

Hi @EN6924 

Try this formula

DateTimeAdd(MONTHEND(DateTimeAdd('1970-01-01 00:00:00',[UnixDateTime]/1000,'seconds')),1,'day') 

Hope this helps : )

[atcodedog05]

Hi @EN6924 

Or this python method

Hope this helps : )

[EN6924]

Thanks but the formula is not working for my case. 😐

Startdateunixsec: 1624557609

Start date which is showing: 2021-06-24 18:00:09 (Thursday, June 24, 2021 6:00:09 PM)

This should show like - Thursday, June 24, 2021 11:30:09 PM

[atcodedog05]

Hi @EN6924 

Was able to get it woking using python

Hope this helps : )

[EN6924]

I'm not familiar with Python yet.  😪

[atcodedog05]

Hi @EN6924 

Use it as plug and play give me the exact name of the input column name I can configure it for you.

Hope this helps : )

[EN6924]

Hi,

I've copied 3 records in Text Input.

These are the columns -

The Startdate will be like - 11:30 PM instead of 6 PM and 2:30 PM instead of 9 AM (You already prepared using Python)

Hope this works..

[allwynthomas24 · Accepted solution]

Hey @EN6924,

Kindly check the attach workflow and confirm whether the output is as per your requirement. 

Thanks & Regards,

Allwyn Thomas

Spoiler