Since yesterday question

My query that contains since yesterday is from "Month day, 06:00 pm until Month Day, 06:00 pm"

How do I correct this to show from midnight to midnight to correct for the UTC offset? I would hope that using “Yesterday” would do that automatically based on timezone.

Hi @reopelle.scott - This is not the default functionality, picking up the user’s timezone. You will need to add it yourself by adding WITH TIMEZONE

Perfect! Thanks. SINCE yesterday until today WITH TIMEZONE 'America/Chicago'