Use of CRON to schedule reports.
I have used CRON to schedule report and noticed the following behavior :
The CRON expression is evaluated towards UTC time, which is OK to me.
The report itself is timestamped with UTC time instead of the User time and the timestamps included in the attached Excel file are also UTC ones.
So, I wonder :
- If it is possible to adjust the timestamp to the User location ?
- What is the behavior of the CRON expression when DST (daylight saving time) adjustments apply
Jared Wiltshire last edited by Jared Wiltshire
@pascal are you talking about Excel reports?
The cron expression should be evaluated against the server timezone AFAIK (it uses the timezone from the OS/JVM by default, you can override this in your env.properties file).
Are you sure you don't have your server timezone set to UTC?
What is the behavior of the CRON expression when DST (daylight saving time) adjustments apply
Good question. Our cron code is based on the Quartz scheduling library v2.1.0, so this should help -
Of course if its actually evaluating the expressions as UTC time then there is no DST.