
Contributor
2024-10-25
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Epoch conversion
How to convert a date from epoch (milliseconds) to date
1 Reply

Partner - Specialist II
2024-10-25
04:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=num(date(today(1)))*86400000 - num(date('1/1/1970'))*86400000
This will give you epoch time in milliseconds for a specified date. Qlik is storing dates as the number of days passed from 1/1/1900, whereas epoch time starts from 1970. Converting the date to milliseconds, and subtracting 1970, will give you the correct epoch time.
