Forum Discussion

MarionKeller's avatar
MarionKeller
New Member
7 years ago

DateDiff with Direct Query as Measure

I need to have the Date Difference between two Date columns   # of Minutes = Datediff(OP_ORDER_ITEM_ARCHIVE[PICKING_AT];OP_ORDER_ITEM_ARCHIVE[REFILLING_AT];MINUTE)   I'm using the DateDiff Func...
luke611's avatar
luke611
Frequent Visitor
6 years ago

I have exactly the same. DirectQuery + Oracle database. Any ideas?

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

DATEDIFF is overrated. Try just subtracting one date from the other. Internally dates are treated as numbers with the whole part representing the days and the fraction representing, well fractions of days. Say you want to know the difference between Date A and Date B in hours, you would write ([Date A]-[Date B])*24