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?

Time Series

Accepted answers

allwynthomas24

Hey @EN6924,

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

Thanks & Regards,

Allwyn Thomas

Spoiler

Unix Epoch DateTime to Windows DataTime - AllwynThomas.yxmd

All comments

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 : )

python convert.yxmd

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

allwynthomas24

Hey @EN6924,

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

Thanks & Regards,

Allwyn Thomas

Spoiler

Unix Epoch DateTime to Windows DataTime - AllwynThomas.yxmd

allwynthomas24

Hey @EN6924

Thank You for marking the above workflow as solution.

Good Day.

Best Regards,

Allwyn Thomas

EN6924

It's working perfectly 😊

atcodedog05

Amazing @allwynthomas24 😀 i will bookmark it for further reference.

@EN6924 Sorry I couldn't get the python method working for your data😅

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280