Date is lower or equal
What this tool does
This tool checks whether one date comes before or is the same as another date. You give it two dates, and it tells you if the first one is earlier than or equal to the second one.
Keep in mind that this comparison depends on how you write the dates. If the dates are not in a standard format, the tool might not understand them correctly, and the result could be unexpected.
Common uses
- Checking if a start date is before an end date
- Verifying if a specific event has already happened or is still upcoming based on a cutoff date
- Sorting or filtering records by date ranges
Input data
| Parameter | Required | Example | Description |
|---|---|---|---|
date1 | Yes | 1975-05-19 | The first date to check, as text in a standard format like '2023-10-05'. This is required. |
date2 | No | 1975-05-20 | The second date to compare against, as text in a standard format like '2023-10-06'. This is optional. |
Output data
| Field | Description |
|---|---|
result | A true or false value. Returns true if date1 is earlier than or the same as date2, and false otherwise (e.g. true). |