all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

how can i sum date, months not integer


how can i sum date, months not integer Jesus Suarez
5/11/2007 5:25:38 PM
sql server reporting services:
Hello

how can i sum date? eg.

getdate + 1.3 months

thanks

Re: how can i sum date, months not integer EMartinez
5/11/2007 7:22:41 PM
On May 11, 10:25 am, "Jesus Suarez" <suarez.lopezje...@gmail.com>
[quoted text, click to view]


If I understand you correctly, you can either do it in a stored
procedure/query via:
dateadd(dd, 40, getdate())
-or-
in the report via an expression similar to:
=dateadd("d", 40, Now()) -or- =dateadd("m", Max(Fields!Months.Value),
Now())
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button