current datetime - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

current datetime

Author

Topic

learntsql

524 Posts

Posted - 2009-11-24 : 07:52:47

Hi..
How to get current date and time as default report parameter ssrs 2005.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-11-24 : 08:00:27

Hi

you expect this..

SELECT CURRENT_TIMESTAMP
GO
SELECT {fn NOW()}
GO
SELECT GETDATE()
GO

-------------------------
R...

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-11-24 : 08:15:16

In parameter setup, select default of Expression and use
=today()

John
It's a small world (but I wouldn't want to paint it)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources