Hi Niha,

Can you please show the errors here.

Datediff will show you the number of intervals. If you want days, leave it as days.

If your input dates, Fields!Date.Value & Fields!Date2.Value are from a database, and they are datetime datatypes, then Datediff will give you the correct result; the number of days between the two dates.

It won't assume dd.mm.yyyy or mm.dd.yyyy

If your two fields are not coming from a database, for example if they are text parameters then it might have problems.

Can you please explain your problem a bit more, where your fields come from, and what the error is?