SSRS: Useful Date & Time Functions

CDateConvert to Date. =CDate(Fields!BirthDate.Value) DateAddReturns a Date value containing a date and time value to which a specified time interval has been added. =DateAdd(“d”,3,Fields!BirthDate.Value) =DateAdd(DateInterval.Day,3,Fields!BirthDate.Value) DateDiffReturns a Long value specifying the number of time intervals between two Date values. =DateDiff(“yyyy”,Fields!BirthDate.Value,”1/1/2007″) =DateDiff(DateInterval.Year,Fields!BirthDate.Value,”1/1/2007″) DatePartReturns an Integer value containing the specified component of …

[FIX] SSRS: The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied)

Once You get error: The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied) Solution: Go to > Start Menu > start Internet Explorer as “Run as Administrator” Open Your Report Server URL Go to Site Settings Security->New Role Assignment In the Report Manager website, click Folder …