Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.
Sign up to join this community
After spending a lot of time solving this for myself I thought I'd share it. In my Craft 2 template I had this query:
{% set result = craft.entries({
section: 'events',
eventDate: ['and', '<' ~ now.w3c(), '> ' ~ now | date_modify('-6 days')],
results: ':notempty:',
order: 'eventDate desc',
with: ['imageGallery'],
limit: 3
}) %}
My Craft 3 version is:
{% set result = craft.entries()
.section('events')
.eventDate( ['and', '<' ~ now|atom, '>' ~ now|date_modify('-6 days')|atom ] )
.results(':notempty:')
.orderBy('eventDate desc')
.limit(3)
.with(['imageGallery'])
.all()
%}
Note the extra |atom after the date_modify('-6 days')
