This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

ukebako8008
ukebako8008

When using daterange list filter, the documentation suggests the following condition string:

published_at:
        label: Date
        type: daterange
        conditions: created_at >= ':after' AND created_at <= ':before'

But be aware that ':after' value contains selected date AT 03:00:00 and ':before' value contains selected date PLUS one day at 01:59:59

For example, if your selected range is 2016-10-27 - 2016-11-08, you will get the following values:
after - 2016-10-27 03:00:00
before - 2016-11-09 01:59:59

If you want just date-based range filter, use the following statement:

conditions: my_date_field >= ':afterDate' AND my_date_field <= ':beforeDate'

1-1 of 1

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.