Date Conditions

is between The parameters for the field are between to sets of factors.
is greater than or equal to The parameters for the field are greater than or equal to these factors.
is greater than The parameters for the field are greater than this factor.
is less than or equal to The parameters for the field are less than or equal to these factors.
is less than The parameters for the field are less than this factor.
is empty The parameters for the field is empty of all characters
is not empty The parameters for the field are not empty of one or more characters.
year one of The parameters for the field include the year being one of this factor.
month one of The parameters for the field include the month being one of this factor.
day of month one of The parameters for the field include the day of the month being one of this factor.
weekday one of The parameters for the field include the day of the week being one of this factor.
day of year one of The parameters for the field include the day of the year being one of this factor.
is in last This condition means that the the date is in the last xx days/weeks/months/years from the current date. You could use this to find:
  • donations in the last week
  • events in the past month
  • volunteers in the past 90 days
  • emails in the past 2 days
  • etc.
is in next This condition means that the the date is in the next xx days/weeks/months/years from the current date. You could use this to find items that are coming up, such as:
  • report on events in the next month
  • letters due to be printed in the next week
  • Volunteer activities scheduled in the next 2 weeks
  • Passes or Gift Certificates about to expire in the next 7 weeks
Diataxis: