Filtering by the agent's time zone

Description

Filtering conditions

• first occurrence

• last occurrence

  • less than x days ago

  • more than x days ago

  • x days ago

  • in x days

  • today

  • yesterday

  • current month

returns the results in UTC time.

This is misleading especially in the case of using automation with the On date & time module, where the difference between the agent's time and UTC time may cause the module to trigger on day X, but the filtering conditions will take into account day X ± 1.

Example

In the case when the agent set the On date & time module to 2022-03-26 00:28, the filter with the condition 2 days ago may not trigger for users who had an event occurrence with the date 2022-03-24 but for users with the date 2022-03-23.

This is due to the fact that the agent had a timezone +1h compared to UTC, and the module filtered users according to the time 2022-03-26 00:28 - 1h (which is 2022-03-25 23:28).