Solved: Date & time convert to Epoch - Qlik Community

manojkulkarni · ‎2017-07-26

Hi Friends,

Is there any function to convert date& time value to epoch format ?

below is the sample

"Wednesday, July 26, 2017 6:38:00 AM" convert to "1501051080" (epoch)

Kushal_Chawda · ‎2017-07-26

try this, make sure that DateField is in number format

=Floor((DateField-MakeDate(1970,1,1))*86400)

View solution in original post

Anil_Babu_Samineni · ‎2017-07-26

I am hearing first time this? What does this 1501051080 indicates? I mean to say any minutes / Seconds ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Kushal_Chawda · ‎2017-07-26

try this, make sure that DateField is in number format

=Floor((DateField-MakeDate(1970,1,1))*86400)

manojkulkarni · ‎2017-07-26

it is in milliseconds

Anil_Babu_Samineni · ‎2017-07-26

Or if it is time(Date field) do multiply 86400000

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

PrashantSangle · ‎2017-07-26

Hi,

might below thread help you

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

manojkulkarni · ‎2017-07-26

Thanks Kushal, it is working.

thuaume · ‎2020-07-17

Using:

LET vTodayUnix = Floor(((Today()-1)-MakeDate(1970,1,1))*86400);

works perfectly fine, Thank you !