Timezone issues when using metadata keywords


Matrix Version:

We use Workplace for our intranet. When creating an event, the backend metadata date (EventStartDate) displays as GMT and the frontend output is automatically adjusted to the users local timezone.

Our problem is that when we use a keyword (%asset_metadata_EventStartDate^date_format:l j F%) to reference the date in an event listing, it shows the GMT date rather than the local date. Because we are only showing the day/date and not the time, events scheduled in the afternoon show the right day/date as it is after 12am GMT, but all events scheduled in the morning show as being on the previous day.

Does anyone know how to use a keyword to reference the metadata date and then add a specific timezone offset to adjust for GMT? We want a specific offset so that it always shows the day in relation to head office so don’t need to worry about the exact timezone where an individual user is located for this particular listing.

Appreciate any help. Thanks.