Profile: simonM-5

Problem:
the user is using a form with the expiration feature. He then queries posts on a view based on the expiration date. But he encounters some issues because the site is using a different timezone than UTC.

Solution:
Expiration dates are stored as timestamp, hence in the UTC timezone.

But the view's query using "NOW" and "SECONDS_FROM_NOW" are calculated in the site's timezone. We'll need to hook into the query and change these dates to UTC.

Check this sample code:

Note that this code assumes that there is only one meta_query on the view. If the view queries another custom field, this code should be modified and adapted