- DarkLight
Relative Operators
- DarkLight
Relative operators enable you to Segment data based on dynamic time frames relative to the current date. For example, using a relative operator like "Due date is after 2 days from now" allows you to capture records where the due date falls exactly two days after the present date, without needing to specify a static date.
The following table explains the Addition Criteria for the Relative operator, Time Period options, and their examples. The examples are provided considering today’s date as January 1, 2024.
Additional Criteria for the Relative Operator | Period | Reference Point | Example |
---|---|---|---|
After | 5 days | From Now | Due Date is after January 6, 2024, which means the Due Date is after that date. |
5 days | Ago | Due Date was 5 days ago, which means the Due Date was December 27, 2023. | |
Before | 1 week | Ago | Due Date is 1 week ago, which means the Due Date was December 25, 2023. |
1 week | From Now | Due Date is 1 week from now, which means the Due Date is before January 8, 2024. |