Forum Discussion

CGanabelle's avatar
CGanabelle
Frequent Visitor
9 years ago
Solved

Calculate difference between two date/time values

Hi everyone, I try to calculate the difference, in terms of time, between two datetime values. The problem is that when I use datediff, there is an error message : "In DATEDIFF function, the start d...
Need Help
  • PavelR's avatar
    PavelR
    9 years ago

    Yeah, I would also try to look for some inconsistencies in DB. I hope you will find it! :smileywink:

     

    You are welcome Anabelle.

    Regards.

    Pavel

PavelR's avatar
PavelR
Solution Specialist
9 years ago

Hi CGanabelle. I use DATEDIFF function and it works right.

 

I just used your example of date valu, then I created another one date value by adding one month and used DATEDIFF function.

 

Result is like this:

DAX: Diff = DATEDIFF(Table1[Date1];Table1[Date2];DAY)

 

Syntax for the function is:

 

DATEDIFF(<start_date>, <end_date>, <interval>

Maybe you just switched the two date columns (parameters) in the function.

 

 

Regards.

Pavel

 

 

CGanabelle's avatar
CGanabelle
Frequent Visitor
9 years ago

Thank you very much for you answer! I've just checked but the error still appear unfortunatly even when I change the format.. I'm going to check if there isn't some inconsistencies in the database.

Thank you again to have tried to help me :)!
Have a nice day,

Regards,
Anabelle