Forum Discussion

rosscortb's avatar
rosscortb
Icon for Post Patron rankPost Patron
6 years ago
Solved

whats wrong with datediff formula?

Hello, 

 

Any ideas why I am getting negative values? Thanks Ross

 

Time to Approve in Days = DATEDIFF(Starters[Job Req Creation],Starters[Job Req Approved],DAY)
 
  • rosscortb ,

     

    Going from December to February? Look at your date columns?

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion

    rosscortb ,

     

    Going from December to February? Look at your date columns?

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • rosscortb's avatar
      rosscortb
      Icon for Post Patron rankPost Patron

      arggg...sorry, so annoying one's, in d/m and the other is m/d

       

      Should have seen that,thanks