datetime for footer

• SheilaC

  SSC-Addicted

  Points: 429

  More actions

  March 25, 2005 at 11:12 am

  #113629

  I am working my first report design that requires a long date as a footer, the problem is that I walk through the date format on BOL and from other's who have designed reports before as well as trying to find something @

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclasstopic.asp

  I just am not getting something, I have thought maybe just create my sproc for getdate() and use this as dataset?

  Please any help would be appreciated as this is a report that has to be deployed by Monday.

   

  Thanks Sheila.

  Sheila Conlon (getting back)

• March 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  March 28, 2005 at 8:07 pm

  #549238

  Did you try putting a 'D' (caps d) in the format property for the textbox item?

  Steve.

• Anonymous

  SSCrazy

  Points: 2228

  More actions

  March 29, 2005 at 6:01 pm

  #549449

  This is what I use in all my report footers (in a Textbox):

  = Format(Now(),"g")

  It gives, for example:

  3/29/2005 1:00 PM

  If you use:

  = Format(Now(),"g")

  It gives, for example:

  Tuesday, March 29, 2005 1:00 PM

  Take a look at the Reporting Services BOL "formatting dates" in the Index and scroll down that page.