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 diff = DATEDIFF([AA Last value date], [AA Latest Actual date] ,DAY)
My dates are
 
 

 

 

 

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

1 Reply

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