Comparing dates using conditional statements
- 01 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Comparing dates using conditional statements
- Updated on 01 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Compare one date against another
Using an IF statement is a quick way to compare two dates. The formula below will compare both dates, and return the second date only if it is greater than the first date, and otherwise show a blank value.
IF({Date 2} > {Date 1}, {Date 2},BLANK())
Output value depending on a date comparison
For another approach, you may want to measure the days between the current date and time, and a static date field (like the date the invoice was billed). Adding in a conditional IF statement allows you to do the following:
- If the payment received field is empty
- And the days passed between the current day and the day the invoice was billed is more than 25 days
- Then output a message to send the customer a reminder
- And if none of the above is true, output a blank value
IF(
AND(
{Payment Received}=BLANK(),
DATETIME_DIFF(
NOW(),{Invoice Billed}, 'days')
> 25
),
"Send customer reminder"
)
Was this article helpful?