Forum Discussion

GoodMan85's avatar
GoodMan85
Frequent Visitor
3 years ago
Solved

Problem with DATEDIFF

Hi Guys, I jhave a problem with DATEDIFF formula. I need to make the formula on date fields of different tables. Please help me.   Ex. DATEDIFF between HH Doc Date and B.P. Req Date.   T...
Need Help
  • mh2587's avatar
    mh2587
    3 years ago

    DateDifference =
    VAR StartDate = MAX(Table[HH Doc Date])
    VAR EndDate = MAX(Table[B.P. Req Date])
         RETURN 
                     DATEDIFF ( StartDate, EndDate, DAY ) 

mh2587's avatar
mh2587
Super User
3 years ago

DateDifference =
VAR StartDate = MAX(Table[HH Doc Date])
VAR EndDate = MAX(Table[B.P. Req Date])
     RETURN 
                 DATEDIFF ( StartDate, EndDate, DAY )