Skip to content

Instantly share code, notes, and snippets.

@Anubarak

Anubarak/andWhere Date format

Created August 1, 2018 18:52
Show Gist options
  • Save Anubarak/dc090b501702ce3ae5219dc054365b97 to your computer and use it in GitHub Desktop.
Save Anubarak/dc090b501702ce3ae5219dc054365b97 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
andWhere Date format
{% set events = craft.entries()
.section('events')
.andWhere('DATE(CONVERT_TZ(field_eventStartDate, "UTC", "Europe/Berlin")) >= ' ~ 'now'|date('Ymd'))
.all() %}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment