Forum Discussion
Date Difference in Direct query
How to calculate the date difference between 2 date columns in Direct query? I tried DateDiff function, but this is not supporting in Direct Query mode
Karthikreddy523 Try:
( [Date 1] - [Date 2] ) * 1.
I tried it,but the results are not accurate and i need the difference in years.Please find the screenshot here