Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Report with date/time

Status
Not open for further replies.

Ringers

Technical User
Feb 26, 2004
180
AU
Hi All,

I have created a whole bunch of reports with SQL BIDS 2005 and I now i need to the current date\time fields whenever the report is run. Can anyone tell me how to do this?

Thanks
 
Take a look at: GETDATE()

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------
 

Presuming these are Reporting services reports then you can add a header or footer to the report and one of the standard items of data you can add is current date and time.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
Thanks for the info dhulbert, i have added text fields and such to the header already. How do i add the date/time, i am missing something obivous?
 
I worked it out, added a text box and used DateString function, easy as.
 
ah... use Today() in the formula for the textbox.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top