Who is online?  0 guests and 0 members
Home  »  Blogs  »  benagee  »  SSRS- Using the Dateadd() function

SSRS- Using the Dateadd() function

change text size: A A A

posted 12/2/2009  by benagee -  Views: [8413] 

The normal SQL date part designators (hh,dd,mi etc. do NOT work. Where Transact/SQL would be DATEADD(Hour,7,@date) SSRS DateAdd is as follows =DateAdd(DateInterval.Hour,7,Parameters!date.Value) Note that the capitalization must be exactly as shown for the date part designator or it wont work. I have only tired “Day” , “Hour” and “Second” but I suspect the rest will work.
 
0
/5
Avg: 0/5: (0 votes)

Comments (no comments yet)

Add a new comment
Blogs RSS Feed

benagee's latest blog posts

Blogs RSS Feed

Latest community blog posts