Help

Comparing dates

Topic Labels: Dates & Timezones
815 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Taskmaster
4 - Data Explorer
4 - Data Explorer

I am trying to compare dates across 4 different columns. Here is the formula I need help with  - 


IF
(DATETIME_DIFF(({Start (from Roadmap)}, {M's Start Date}) /This is trying to compare dates in two columns
 
OR / This is to ensure the second set of date comparisons are also accounted for.
 
((DATETIME_DIFF({End (from Roadmap)}, {M's End Date copy})))) /This is trying to compare the second set of dates in two columns
 
If the first or second condition is true i.e the dates don't match I need it to return a value of say 1.
 
Can someone help correct this for me ?
2 Replies 2
IF(
  OR(
    NOT(IS_SAME(
      {Start (from Roadmap)},
      {M's Start Date},
      "day"
    )),
    NOT(IS_SAME(
      {End (from Roadmap)},
      {M's End Date copy},
      "day"
    ))
  ),
  "Dates do not match"
)
 
Taskmaster
4 - Data Explorer
4 - Data Explorer

OMG ! Thank you so much !! You are amazing