BetweenDates

Determine if a date is between two dates.

Will compare inclusive of the dates used (ignoring time). Can be arranged in any order e.g. BetweenDates(Today, "15-10-2010") or replace Today with a date e.g. BetweenDates("15-10-2010","23-10-2010").

Expression	Databox Value	Result	Comments
BetweenDates ("15-10-2030",Today)	15-10-2027 08:00pm	True	Will compare inclusive of the dates used (ignoring time)
BetweenDates (Today, "15-10-2030")	15-10-2027 08:00pm	True	Arguments can be arranged in any order
BetweenDates(“15-10-2030”,”23-10-2010”)	15-10-2019 08:00pm	False	Or supply two dates

Example

The Expressions above could be used to check whether the date entered by the operator, or the date picked up by the system is before, after or within a time-frame. For example, to check the date of a claim against an insurance policy or warranty, or whether the enquiry is before or after a change in company Policy, to ensure the appropriate action. The example below shows an Expression being tested and returning True or False if an entered date is within range:

Example of the BetweenDates expression