Problem Formatting Date

[Wayne Wengert]

I am using VB.NET - VSNET 2003 and accessing data from an SQL Server. I am
trying to convert a datetime field retrieved from the DB to a format like
"MM/DD/YYYY" - I want results like "10/28/2004". I am trying the code:

CDate((rdr1.Item("Date"))).ToString("MM/DD/YYYY")

but when I look at the output it looks like this:

02/DD/YYYY

Here is a copy of the test I did while stepping through the code:

?CDate(rdr1.Item("Date")).ToString("MM/DD/YYYY")

"02/DD/YYYY"



What am I doing wrong?



Wayne

 

[Herfried K. Wagner [MVP]]

CDate((rdr1.Item("Date"))).ToString("MM/DD/YYYY")

but when I look at the output it looks like this:

02/DD/YYYY

\\\
.... = foo.ToString("MM/dd/yyyy")
///

 

[Jay B. Harlow [MVP - Outlook]]

Wayne,
As Herfried pointed out, the format string you use is case sensitive. For
example "MM" means months, while "mm" means minutes.

For details on custom datetime formats see:

http://msdn.microsoft.com/library/d...s/cpguide/html/cpcondatetimeformatstrings.asp

For information on formatting in .NET in general see:
http://msdn.microsoft.com/library/d...y/en-us/cpguide/html/cpconformattingtypes.asp

Hope this helps
Jay

 

[Wayne Wengert]

Herfried & Jay;

Boy, am I feeling stupid. I overlooked the case sensitivity. Thanks for the
help.

Wayne