=GTDATE (Greater Than Date)
The GTDATE function compares two dates and returns whether the first date is greater than (later than) the second date. Useful for date validation, conditional logic, and workflow decisions.
Syntax
Section titled “Syntax”=GTDATE(IsThisDate; GreaterThanThisDate)Parameters
Section titled “Parameters”-
IsThisDate – The date you want to evaluate.
-
GreaterThanThisDate – The date to compare against.
How It Works
Section titled “How It Works”-
Returns 1 (true) if IsThisDate occurs after GreaterThanThisDate.
-
Returns 0 (false) if IsThisDate is equal to or before GreaterThanThisDate.
-
Supports both static dates and process field date tokens.
Usage Notes
Section titled “Usage Notes”-
Dates must be valid and in a recognized date format (e.g., YYYY-MM-DD).
-
Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=GTDATE([[Field: Date 1 (Date)]]; [[Field: Date 2 (Date)]])-
Returns 1 if Date 1 is later than Date 2.
-
Returns 0 if Date 1 is the same or earlier than Date 2.
Keywords
Section titled “Keywords”GTDATE, GREATERTHANDATE, compare dates, date comparison, conditional logic, workflow formulas, true/false, process field date, formula function