Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert epoch to human-readable date

EN6924
10 - Fireball

My data is like below -

 

EN6924_0-1646657902295.png

 

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

EN6924_1-1646658003573.png

 

Need to add GMT+5:30

How should I convert it?

14 REPLIES 14
mbarone
16 - Nebula
16 - Nebula

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
22 - Nova
22 - Nova

Hi @EN6924 

 

Try this formula

 

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

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @EN6924 

 

Or this python method

 

atcodedog05_0-1646659149822.png

 

Hope this helps : )

 

EN6924
10 - Fireball

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
22 - Nova
22 - Nova

Hi @EN6924 

 

Was able to get it woking using python

 

atcodedog05_0-1646660720238.png

 

Hope this helps : )

 

EN6924
10 - Fireball

I'm not familiar with Python yet.  😪

atcodedog05
22 - Nova
22 - Nova

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
10 - Fireball

Hi,

 

I've copied 3 records in Text Input.

 

These are the columns -

EN6924_0-1646662370403.png

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
11 - Bolide

Hey @EN6924,

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

Thanks & Regards,

Allwyn Thomas

 

 

Spoiler
allwynthomas24_0-1646664148467.png
Labels