Well, there are a few ways to solve this.
- Ensure all your servers timezones are set to UTC (even if they don’t live in UTC), then all your timestamps arrive in UTC.
- Alternatively hook up a pipeline or two, parse the log dates (flex_date_parse is great), and ensure you convert to UTC, then replace the original timestamp field with the new timestamp in UTC.
- There is no 3.
Also make sure that in your user profile you have set your timezone properly because it does take that into account.