Date Field Question

Hi,
In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in
reporting ?
i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value)
Thank You!
TonyTony,
It should be the same.
Check out this link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdateadd.asp
Tony wrote:
> Hi,
> In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in
> reporting ?
> i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value)
> Thank You!
> Tony|||SQL remains the same. If trying to calculate in reporting services, you need
quotes for the VB syntax.
= DateAdd("d", -1, Parameters!FromDate.Value)
"toolman" wrote:
> Tony,
> It should be the same.
> Check out this link:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdateadd.asp
>
> Tony wrote:
> > Hi,
> >
> > In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in
> > reporting ?
> >
> > i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value)
> >
> > Thank You!
> > Tony
>|||Thanks All!
"William" wrote:
> SQL remains the same. If trying to calculate in reporting services, you need
> quotes for the VB syntax.
> = DateAdd("d", -1, Parameters!FromDate.Value)
>
> "toolman" wrote:
> > Tony,
> > It should be the same.
> > Check out this link:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdateadd.asp
> >
> >
> > Tony wrote:
> > > Hi,
> > >
> > > In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in
> > > reporting ?
> > >
> > > i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value)
> > >
> > > Thank You!
> > > Tony
> >
> >