How is set the time of the change of the date?

[Flavio4]

Hello,

I am running a collector job for an indicator based on a indicator source selecting the period 1.1.2015 00:00:00 to "This week", see screenshot:

Unfortunately the job log shows that the actual selected period runs from one hour before the 1.1.2015 to 2 hours before the end of this week (should be 2024-09-08 23:59:59):

SELECT task0.`sys_id` FROM task task0 WHERE (task0.`sys_class_name` = 'incident' OR task0.`sys_class_name` = 'u_request_fulfillment') AND ((task0.`closed_at` >= '2014-12-31 23:00:00' AND task0.`closed_at` <= '2024-09-08 21:59:59') OR task0.`closed_at` IS NULL )

I imaging that something is wrong with some "change of the day" settings, less likely with time zones.
Unfortunately I couldn't find explanations about that.

Can anybody suggest how to fix this?

Thank you
Flavio

[Mark Manders]

It could be a difference between the system time and the time zone the job is running on (or timezone of the user that is running the job or even the timezone from the user creating the job). Can you check on that? 

[Flavio4]

Hi Mark,

thank you for your effort.

I checked and apparently all the time zone configurations involved correspond:

- the user(me) time zone
- the time zone of the Performance Analytics user used to run the collector job
- the time zone in Run as tz in the collector job

are all set to the system default, that is "System (Europe/Paris)" and the system property glide.sys.default.tz is set to Europe/Paris.

Any further suggestions?