K3 Documents

Compare Dates

Updated Nov 22, 2019

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


Compare dates and return a value based on the comparison

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


Return a bool if the date is after

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


 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