How can i retrieve dates from a table in my db based on a varying timezone that i pass in through a query?
For example: if i have a table of payments, with payment dates stored in UTC, I'd like to retrieve all the payments made for my shop in the US Eastern timezone for a report. The field filter doesnt allow to account for the -5 hour offset, and therefore there is a weird gap in values towards the end of the day. Because of this, a date filter range of "Today" ends 5 hours early, and starts on the day prior.
Whats the current fix for this?