Date operators

Date operators define conditions based on dates.
Table 1. Date operators
Operator Description Example
<a day of week> is after <a day of week> Tests that a day of the week comes after another day of the week.
Note: Sunday is considered to be the first day of the week. 
if
   the day of the return date of ’rented car’
      is after Friday
then...
<a day of week> is before <a day of week> Tests that a day of the week comes before another day of the week.
Note: Sunday is considered to be the first day of the week. 
if
   the day of the return date of ’rented car’
      is before Friday
then...
<date> is after <date> Tests that a date comes after another date. 
if
   the return date of ’rented car’ is after 05/07/2007 05:00:00 PM
then...
<date> is after <date> and on or before <date> Tests that a date is in a range in which the first date is excluded, and the last date is included. 
if
   the return date of ’rented car’ is after ’pickup date’ and on or before ’scheduled return date’
then...
<date> is after <date> and before <date> Tests that a date is in a range in which both dates are excluded. 
if
   the return date of ’rented car’ is after ’pickup date’ and before ’scheduled return date’
then...
<date> is after or the same as <date> Tests that a date comes after another date, or is the same as that other date. 
if
   the return date of ’rented car’
      is after or the same as 05/07/2007 05:00:00 PM
then...
<date> is at <time> Tests that the time part of a date is at the specified time. 
if
   the return date of ’rented car’ is at 05:00:00 PM
then...
<date> is before <date> Tests that a date comes before another date. 
if
   the return date of ’rented car’ is before 05/07/2007 05:00:00 PM
then...
<date> is before or the same as <date> Tests that a date comes before another date, or is the same as that other date. 
if
   the return date of ’rented car’
      is before or the same as 05/07/2007 05:00:00 PM
then...
<date> is in <month> Tests that a date is in a specific month. 
if
   the return date of ’rented car’ is in October
then...
<date> is in <month> the year <year> Tests that a date is in the specified month of the specified year. 
if
   the return date of ’rented car’ is in October the year 2007
then...
<date> is in the year <year> Tests that a date is in the specified year. 
if
   the return date of ’rented car’ is in the year 2007
then...
<date> is on <a day of week> Tests that a date is on a specific day of the week. 
if
   the return date of ’rented car’ is on Thursday
then...
<date> is on <simple date> Tests that a date is on a specific date, specified without a time. 
if
   the return date of ’rented car’ is on 05/07/2007
then...
<date> is on <day of week> at <time> Tests that a date is on a specific day of the week, at a specific time. 
if
   the return date of ’rented car’ is on Thursday at 05:00:00 PM
then...
<date> is on or after <date> and before <date> Tests that a date is in a range in which the first date is included, and the last date is excluded. 
if
   the return date of ’rented car’
      is on or after ’pickup date’ and before ’scheduled return date’
then...
<date> is on or after <date> and on or before <date> Tests that a date is in a range in which both dates are included. 
if
   the return date of ’rented car’
      is on or after ’pickup date’ and on or before ’scheduled return date’
then...