Comparison Operators
- DarkLight
Comparison Operators
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Comparison operators for date data types allow you to compare the values of two different date fields. For example, operators like "is more than" or "is less than" can evaluate whether one date field (e.g., "Start Date") occurs before or after another date field (e.g., "End Date"), while "is same as" and "is different" help identify records where the dates match or differ.
The following table explains the period options and relevant examples.
Period Option | Description | Reference Dates |
|---|---|---|
Between | Checks if the date in one field falls within a specified range, which can be defined using either specific dates or rolling periods such as days, weeks, or months. | "Start Date is between January 1, 2024, and March 31, 2024" or "Start Date is between last week and this week" – finds records within the defined range. |
Is same as | Compares if two date fields match exactly, whether for date, day, week, month, quarter, or year | "Order Date is same Week as Delivery Date" – matches records where both dates fall on the same week. |
Is different | Compares if two date fields do not match, for any specified time period (date, day, week, month, quarter, or year). | "Billing Date is different Month from Payment Date" – finds records where the months of these dates don't align. |
Is more than | Checks if the date in one field is after another field by a specified time period (day, week, month, or quarter). | "Follow-up Date is more than 1 week after Appointment Date" – captures records with this time gap. |
Is less than | Checks if the date in one field is before another field by a specified time period (day, week, month, or quarter). | "Contract End Date is less than 1 month before Renewal Date" – captures contracts near expiration. |
Was this article helpful?