Forum Discussion

Pick's avatar
Pick
Helper II
6 years ago
Solved

DATEDIFF not working

Hi,

 

  Why is DATEDIFF not working below?

 

Need Help
  • tkirilov's avatar
    tkirilov
    6 years ago

    Hi Pick ,

    You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers.

     

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

3 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    6 years ago

    Pick please try this

    DATEDIFF('Table'[Start],'Table'[End],SECOND)
  • tkirilov's avatar
    tkirilov
    Resolver I
    6 years ago

    Hi Pick ,

    You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers.

     

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