Forum Discussion

Annemie19's avatar
Annemie19
Icon for Helper II rankHelper II
6 years ago
Solved

DATEDIFF Measure error

Hi there,   I need to get the days between two dates. The two dates are both measures.  I keep getting the error below, even if I swop the dates.     The formula I used is:   AA Days di...
  • amitchandak's avatar
    amitchandak
    6 years ago

    Annemie19 , This should have work

    AA Days diff = if([AA Last value date]< [AA Latest Actual date], DATEDIFF([AA Last value date], [AA Latest Actual date] ,DAY), DATEDIFF([AA Latest Actual date] ,[AA Last value date], DAY))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Annemie19 , This should have work

AA Days diff = if([AA Last value date]< [AA Latest Actual date], DATEDIFF([AA Last value date], [AA Latest Actual date] ,DAY), DATEDIFF([AA Latest Actual date] ,[AA Last value date], DAY))