SQL Report with date/time

[Ringers]

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

 

[ousoonerjoe]

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
--------------------------------------------------

 

[dhulbert]

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)

 

[Ringers]

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?

 

[Ringers]

I worked it out, added a text box and used DateString function, easy as.

 

[ousoonerjoe]

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
--------------------------------------------------