Filter Criteria
From Moving Pictures
Date values
a date field supports the following operators:
| EQUAL
|
| NOT_EQUAL
|
| GREATER_THAN
|
| LESS_THAN
|
The time portion of dates is currently not implemented.
only the date part is used when comparing.
Using relative dates
The tables below are describe how you can use relative dates in the value field when adding filter criteria to compare date fields. To get some live examples from the plugin you can add the dynamic category "Date Added" and convert it to a manual one to view the filter criteria.
Tokens (date parts)
| token | with modifier | without modifier
|
| d
| day
| today
|
| w
| week span, date within 7 days (ago)
| start of this week
|
| W
| week boundaries start of week
| start of this week
|
| m
| month span, date within a month (ago)
| start of this month
|
| M
| month boundaries, start of month
| start of this month
|
| y
| year span, date within a year (ago)
| start of this year
|
| Y
| year boundaries, start of year
| start of this year
|
Modifiers
| modifier | description
|
| +n
| add token multiplied by n to today's date
|
| -n
| substract token multiplied by n to today's date
|
Examples
| example | description | result
|
| d
| today
| 30/9/2009
|
| -1d
| yesterday
| 29/9/2009
|
| +1d
| tomorrow
| 1/10/2009
|
| -3d
| 3 days ago
| 27/9/2009
|
| -6y
| 6 years ago
| 30/9/2003
|
| m
| start of this month
| 1/9/2009
|
| -3w
| 3 weeks ago
| 9/9/2009
|
| w
| start of this week
| 27 or 28/9/2009 depends on locale
|
| +1Y
| start of next year
| 1/1/2010
|