sql server reporting services: =now() -- sql server reporting services

You're in the

sql server reporting services

group:

=now()

Re: =now()

Robert Bruckner [MSFT]
8/25/2004 9:47:39 AM

sql server reporting services:

Try =Today.AddDays(-2) or =Now.AddDays(-2)

More information on the DateTime class:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimememberstopic.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

=now()

Rory McCaw
8/25/2004 12:15:20 PM

I am using the =now() expression in one of my reports but the SQL statement
I am using uses runs the report based on data from 2 days ago. Is it
possible to use something like =now()-2 to give the accurate date of the
report data? =now()-2 doesn't work, and I have searched Books online, and
help but haven't found anything.

Thanks!

Rory

Re: =now()

Teo Lachev
8/25/2004 12:51:02 PM

Try

=Now().AddDays(-2) or
=DateTime.Now().AddDays(-2)

The VB.NET Now() function returns .NET DateTime structure type. Check with
the VS.NET documentation to find out all methods exposed by DateTime.
--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

Re: =now()

Rory McCaw
8/25/2004 1:07:16 PM

Thanks!

=Now.AddDays(-2) worked great!

Rory

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn