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"
Click to copy
Description:
Return a bool if the date is after
{Start Date}.after({End Date})
Click to copy
Description:
Return a bool if the date is bool
{Start Date}.before({End Date})
Click to copy