Skip to main content

Comparing dates

  • March 23, 2023
  • 2 replies
  • 25 views
T
Forum|alt.badge.img+2

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

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • March 23, 2023
    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"
    )
     
    T
    Forum|alt.badge.img+2
    • Taskmaster
    • Author
    • New Participant
    • 1 reply
    • March 23, 2023

    OMG ! Thank you so much !! You are amazing

     


    Terms & ConditionsAccessibility statement