DateField

Date field

Filters available

• later than
• earlier than
• equal to or later than
• equal to or earlier than
• to

Date formats

These values can be used with the filters above

• y
• y-m
• y-m-d
• y-m-d H:i:s

Sample dates

1. 2011-05-10 2:00pm
2. 2011-06-01 12:00am
3. 2010-07-01 3:00pm
4. 1960-10-10 2:00am
5. 2012-03-04 7:30pm

Tests

later than

• later than 2011 should return 5.
• later than 2012 should return nothing.
• later than 1960 should return 1, 2, 3, 5.
• later than 2011-05 should return 2, 5.
• later than 2011-05-02 should return 1, 2, 5.
• later than 2010-05-10 1:00pm should return 1, 2, 3, 5.
• later than 2011-05-10 11:00am should return 1, 2, 5.
• later than 2011-05-10 2:00pm should return 2, 5.
• later than 2011-06-01 8:00pm should return 5.

earlier than

• earlier than 2011 should return 3, 4.
• earlier than 2012 should return 1, 2, 3, 4.
• earlier than 1960 should return nothing.
• earlier than 2011-05 should return 3, 4.
• earlier than 2011-05-02 should return 3, 4.
• earlier than 2011-07-01 11:00am should return 1, 2, 3, 4.
• earlier than 2011-05-10 2:00pm should return 3, 4.
• earlier than 2011-06-01 8:00pm should return 1, 2, 3, 4.

equal to or later than

• equal to or later than 2011 should return 1, 2, 5.
• equal to or later than 2012 should return 5.
• equal to or later than 1960 should return 1, 2, 3, 4, 5.
• equal to or later than 2011-05 should return 1, 2, 5.
• equal to or later than 2011-05-02 should return 1, 2, 5.
• equal to or later than 2010-05-10 1:00pm should return 1, 2, 3, 5.
• equal to or later than 2011-05-10 11:00am should return 1, 2, 5.
• equal to or later than 2011-05-10 2:00pm should return 1, 2, 5.
• equal to or later than 2011-06-01 8:00pm should return 5.

equal to or earlier than

• equal to or earlier than 2011 should return 1, 2, 3, 4.
• equal to or earlier than 2012 should return 1, 2, 3, 4, 5.
• equal to or earlier than 1960 should return 4.
• equal to or earlier than 2011-05 should return 1, 3, 4.
• equal to or earlier than 2011-05-02 should return 3, 4.
• equal to or earlier than 2010-05-10 1:00pm should return 4.
• equal to or earlier than 2011-05-10 11:00am should return 3, 4.
• equal to or earlier than 2011-05-10 2:00pm should return 1, 3, 4.
• equal to or earlier than 2011-06-01 8:00pm should return 1, 2, 3, 4.

to

• 2011 to 2012 should return 1, 2, 5.
• 2011-05 to 2012-05 should return 1, 2, 5.
• 2011-05-01 to 2011-06-10 should return 1, 2.
• 2010-06-01 2:00pm to 2011-06-01 11:00pm should return nothing.
• 2010-05-01 11:00am to 2011 should return 1, 2, 3.
• 2010-05-01 11:00am to 2011-05 should return 1, 3.
• 2010-06-01 12:00am to 2010-06-01 9:30pm should return 2.

Direct

• 2011 should return 1, 2.
• 2010-05 should return nothing.
• 2011-06-01 should return 2.
• 2011-06-10 2:00pm should return nothing.
• 1960-10-10 2:00am should return 4.

Relative

• "Last 24 hours", equal to or later than now - 24 hours
• "In 6 weeks", equal to or later than now + 6 weeks
• "Between now and 6 weeks", now to now + 6 weeks