Issue
When creating an extract, you may encounter the following warning:The extract has a different time zone from the underlying server. Calculations using TODAY() and NOW() and relative date filters will give different results.
DATEADD('hour', -7, [Date])
[DateTimeField] >= {FIXED: MAX(DATETRUNC('hour', [DateTimeField]))}
[DateTimeField] >= DATEADD('hour', -5, NOW())