Date Difference in Direct query

Question

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

greg_deckler · Answer

Karthikreddy523&nbsp;Try:
( [Date 1] - [Date 2] ) * 1.

anonymous · Answer

I tried it,but the results are not accurate and i need the difference in years.Please find the screenshot here&nbsp;

anonymous · Answer

Are there any other ways of addressing this Date Difference issue in Direct Query?

grazitti_sapna · Answer

Hey,&nbsp;You can try using &nbsp;([Date A]-[Date B])*24.

cathyt · Answer

None of the above options work.&nbsp; I always get the "not supported in directquery mode" message.

Forum Discussion

Date Difference in Direct query

5 Replies

Related content

merging direct query queries

RLS over Direct Query

Direct Query issue with Snowflake

MySQL Connector - Direct Query

History Data in Direct Query