My data is like below -
Checked from https://www.epochconverter.com/
Need to add GMT+5:30
How should I convert it?
Solved! Go to Solution.
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?
Hi @EN6924
Try this formula
DateTimeAdd(MONTHEND(DateTimeAdd('1970-01-01 00:00:00',[UnixDateTime]/1000,'seconds')),1,'day')
Hope this helps : )
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
I'm not familiar with Python yet. 😪
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 : )