Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


stevja01
2025-05-29T17:03:04Z
Any ideas how to create a variable for an Epoch Date?
For example: the epoch timestamp 1687818708818 = June 26, 2023
Sponsor
Forum information
bweston
2025-06-05T16:47:09Z
Took me a moment to realize the reason my first attempt got an arithmetic overflow was because your number is in milliseconds - not seconds, which I believe is the standard expectation for a unix timestamp.

Naturally, you're gonna need to be sure which you're dealing with for this to work.

{DATEADD(Seconds|1970-01-01 00:00:00Z|u|{MATH(Divide|Double|1687818708818|1000|#0)}|yyyy-MM-dd)}
bweston
2025-06-05T16:48:14Z
Took me a moment to realize the reason my first attempt got an arithmetic overflow was because your number is in milliseconds - not seconds, which I believe is the standard expectation for a unix timestamp.

Naturally, you're gonna need to be sure which you're dealing with for this to work.

{DATEADD(Seconds|1970-01-01 00:00:00Z|u|{MATH(Divide|Double|1687818708818|1000|#0)}|yyyy-MM-dd)}
Scroll to Top