Thanks for your time and explanation.

Here I want to share my issue,

Day1: 09.01.2013 (dd.mm.yyyy)

Day2: 08.01.2013 (dd.mm.yyyy)

Datediff column has to show the difference between dates as per the below expression ,

Expression: “ =Cdec(DateDiff(DateInterval.Day,Fields!Date.Value,Fields!Date2.Value))*(-1)”

But it is taking the above dates as 09.01.2013(mm.dd.yyyy) & 08.01.2013 (mm.dd.yyyy) as per the values of datediff, I have replaced the above expression with Year and checked values. It has to give all ‘Zero’ values as passing year is same for Date1,Date2 fields.

Still it is showing the errors.

“ =Cdec(DateDiff(DateInterval.Year,Fields!Date.Value,Fields!Date2.Value))*(-1)”

any Help would be appreciated..

Thanks,

Niha