Date is between dates
What this tool does
Check if a specific date falls between two other dates.
This tool compares dates to see if the first date is earlier than or equal to the second date and later than or equal to the third date. If the dates are not in a valid order (for example, if the second date is after the third date), the check will simply say 'no'.
Common uses
- Checking if an event happened within a specific time window
- Validating that a date is within a valid range
Input data
| Parameter | Required | Example | Description |
|---|---|---|---|
date1 | Yes | 1975-05-20 | Enter the date you want to check, for example '1975-05-20'. This is required. |
date2 | Yes | 1975-05-19 | Enter the start of the range, for example '1975-05-19'. This is required. |
date3 | Yes | 1975-05-22 | Enter the end of the range, for example '1975-05-22'. This is required. |
Output data
| Field | Description |
|---|---|
result | A yes/no indicator showing if the first date is between the other two. For example, if the dates are correct, it returns true. |