Feature Feature: Enhanced Dates

All you ever wanted to know about dates but were too afraid to ask.

Introduced in v3.77.0, these new date filters are pretty powerful and simplify previously complex tasks. Here is a run down of each new filter with notes and examples to get you up to speed.

is
The most flexible of the new filters, is comes with three additional criteria: value, period and offset.

For example:
Booking Date is 5 day(s) ago would return all bookings made 5 days prior to today.

The period criteria is pretty special too in that you get a day's worth of results for "day", a week's worth of results for "week" and a month's worth of results for "month"!

For example:
Departure Date is 2 month(s) away would return all departures for the entire month of October (assuming you ran this criteria in August).

Bonus info: a value of 0 means this... Last Contact is 0 month(s) away would return all contacts who have been in touch this month.

is today
Simply checks if the given date is today.

For example:
Departure Date is today would return all contacts departing today.

is before today and is after today
Only returns records where the given date is before today or is after today.

For example:
Last Contact is before today would return all contacts that have been in touch prior to today.

is today and before and is today and after
Similar to is before today and is after today but also including anything happening today.

For example:
Departure Date is today and after would return all contacts departing either today or in the future.

year is equal to, month is equal to, week is equal to and day is equal to
Each of these compares the given part of a given date to the specified criteria.

For example:
Departure Date month is equal to February would return all contacts that ever departed in a February.
Last Contact year is equal to 1999 would return all contacts that haven't been in touch for quite a while.

anniversary is today and first anniversary is today
Checks if the anniversary of a given date is today. Either any anniversary (including the first) for anniversary is today or the first for first anniversary is today.

For example:
Booking Date first anniversary is today would return all bookings made on this day last year.

is within the last and is within the next
Returns all matching dates within the last or next given days time including today.

For example:
Enquiry Date is within the last 30 days would return all enquiries in the last 30 days, including those made today.