Compare Dates

Updated Nov 22, 2019

Copy and Paste the following formula using your data where necessary.

Description:

Compare dates and return a value based on the comparison

({Date1}.compareTo({Date2})==0) ? "Field1" : "Field2"

Description:

Return a bool if the date is after

{Start Date}.after({End Date})

Description:

 Return a bool if the date is bool

{Start Date}.before({End Date})
Previous Article Add/Subtract Time to a Date
Next Article Add Months or Dates to Date and Compare