Forum Discussion

Annemie19's avatar
Annemie19
Helper II
5 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
    5 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
Super User
5 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))