how to calculate date difference between two date

[Satish_Kumar]

Hi,

I am trying to calculate date difference two dates which in two different column but when i am applying DATEDIFF its gives me error

please suggest me where i am doing wrong.

Regards,

Satish

[Interkoubess]

Hi @Satish_Kumar,

Please remove the minus(-) between the date and replace it by comma(,).

You can see how datediff works: 

DATEDIFF(<start_date>, <end_date>, <interval>)  

Hope it helps...

Ninter

[Satish_Kumar · Accepted solution]

this is working for now...

Day Difference = DATEDIFF(('GRN Pst TO GRN Entry Date'[GRN_POSTING_DATE].[Date]),('GRN Pst TO GRN Entry Date'[GRN_ENTRY_DATE].[Date]),DAY)