I store the last open times for my emails in a separate Data Extension queried from the
_opens data view.
The problem I have is that I need to be able to see who's received an email today via a filter, but because the timestamps are in UTC this doesn't work how I want.
What is the best way to handle this? Should I manually offset the times?