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)}
stevja01
2025-06-11T19:57:31Z

How would I setup a variable though to come up with FRIDAY's date in EPOCH so the correct file will be downloaded.

For example:
FILE_1687818708818.txt

I want to setup 1678718708818 as a variable for the FILE MASK. Hope that makes sense.
Scroll to Top