Overview:
Flash reports give users the option to schedule reports on a daily, weekly, or monthly frequency and distribute them, via email, to users with the Owner, Editor, or Viewer role.
A Report is configured with the following filter condition:
Product > Created Date is in the last "1 days"
Users schedule the flash report with the Only send when at least one record is returned option. This option means only Products created in the last 1 day are returned. If no product is created in the last 1 day, the flash report is not sent out.
However, the flash report is sent with Products that are created 2 days ago. Why does this happen?
Root Cause:
A filter with the created date in the last 1 day is entirely based on UTC. The time period spans from the end of the day to the beginning of the day before based on the current UTC date.
Example:
The flash report runs at 8 AM 12/23/2020 KST. Converting to UCT, it is 11 PM 12/22/2020 UTC. Based on the UTC time, the date-time in the last one day is between 2020-12-21 00:00:00.000 and 2020-12-22 23:59:59.999 UTC. Converting back to KST, it is 2020-12-21 09:00:00.000 and 2020-12-23 08:59:59.999 KST. That is why the products created on 2020-12-21 are still returned in the flash report on 12/23/2020.
Solution:
To obtain the data within the last 24 hours, use the Now() function instead so that date-times to date-times are compared.
Created Date is in the range now()-1 to now()
Note: If users use today() or in the last 1 day, it converts the Created Date to date first which is calculated using UTC.
Related Documentation:
N/A