Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

Calculate the difference between 2 dates

I need your help guys.   It's a simple question and i hope the anwer is simple   I got dates formatted like 3-2-2017 08:00:00 and 3-2-2017 12:13:00 and i need the difference in minutes if that is...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    RvdHeijden

    RvdHeijden wrote:

    it states that in DATEDIFF function, the start date cannot be greater than the end date

     

    If you used my formula you should not be getting this error!

    See picture...

    if start before end +

    if end before start -

    If both are blank you get zero

    if either one is blank you get blank

    But no you can mix text and number data types in the same column!

    (meaning you can't get numbers when the data is there and then text when its not - but you will get blanks or zero)

     

     

    Hope this helps!

    Good Luck! :smileyhappy:

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

Sean i copied this formula in another colum and changed the colums for the formula, nothing else but it still reads as an #ERROR.

In DATEDIFF function, the start date cannot be greater than the end date

 

The new colums only have date values and no tekst

 

 

DATEDIFF Hersteltijd =
SWITCH (
    TRUE ();
    Tickets[Monteur gearriveerd] < Tickets[Technisch gereed]; DATEDIFF ( Tickets[Technisch gereed]; Tickets[Monteur gearriveerd]; MINUTE );
    Tickets[Technisch gereed] > Tickets[Monteur gearriveerd]; DATEDIFF ( Tickets[Monteur gearriveerd]; Tickets[Technisch gereed]; MINUTE ) * -1;
    0
)

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

Sean i found the reason why for formula returns an error and i used the wrong colums in the formula.

I corrected the mistake and now it works flawlessly