Wednesday 30 January 2013

SSRS Some Tips


For getting Month and Year :

=Monthname(Datepart("m",Fields!duedateValue.Value)) & " " & Datepart("yyyy", Fields!duedateValue.Value)

Result: May 2013.

Difference Between two Dates:

=DateDiff("d",Fields!tvsi_approveddateValue.Value,Fields!actualclosedateValue.Value)

it will give the
result : 2.


For Month only :

=MonthName(Month(Fields!datedeliveredValue.Value))

No comments:

Post a Comment