Check for overlapping date ranges in the table.
The table includes fields that represent start and end dates. An error will occur if the date ranges from start to end overlap between rows.
If an error occurs, it will appear in both the start and end time fields.
The determination of whether the end date of one row and the start date of another row are the same day is defined by the parameter “If the start date equals the end date.”
To check for overlaps that include time, use “Check for Overlapping Date Ranges in Table.”
If an error occurs, the result of the action will be a list containing a single element: the field code of the table where the error happened. If there are no errors, the result will be an empty list.
Set Start Date, End Date, If the start date is the same as the end date, and Error Message.
Select the field for start date. Only the fields inside the table can be selected.
This parameter accepts the following field types:
Select the field for end date. Only the fields inside the table can be selected.
This parameter accepts the following field types:
Set whether to consider the start date of one row and the end date of another row on the same day as overlapping or not.
Enter the error message to be displayed in case of an error.
If the start date is in the future compared to the end date, a normal overlap judgment will not be made.
This Do is not compatible with krewSheet
Only checks within a single table are possible. Cross-checking across multiple tables is not possible.