Forum Discussion
Satish_Kumar
Helper V
Helper Vhow to calculate date difference between two date
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
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)
2 Replies
InterkoubessSolution Sage
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
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)