Groups | Blog | Home
all groups > sql server reporting services > february 2005 >

sql server reporting services : format Date


Chuck
2/17/2005 12:27:02 PM
Hi,

How do I format dateme to i.e. Thursday, February 17,2005? Thanks.


Jessica C
2/17/2005 12:33:43 PM
Fomat(datefield,"D")

[quoted text, click to view]

Chuck
2/17/2005 1:03:07 PM
Hi Jessica,

Thanks for your prompt reply. When I format it as
="Date: " & Fomat(datetime.today,"D") in a text box, I got an error saying
'Name 'Format' is not declared'. Any way to solve it? Thanks again.



[quoted text, click to view]
Mike G.
2/17/2005 4:08:40 PM
Format with an "r"

Mike G.

[quoted text, click to view]

John
2/18/2005 12:43:50 PM
You need to use VBScript functions in Report Designer.

Try:

="Date: " & FormatDateTime(datetime.today, 2)


[quoted text, click to view]

AddThis Social Bookmark Button