Forum Discussion

Pick's avatar
Pick
Helper II
6 years ago
Solved

DATEDIFF not working

Hi,     Why is DATEDIFF not working below?  
Need Help
  • smpa01's avatar
    smpa01
    6 years ago

    Pick please try this

    DATEDIFF('Table'[Start],'Table'[End],SECOND)
  • 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>) 

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>)