'Format' method to convert date format

[thomasc1020]

This is regarding VB.NET 2003.

Variable 'Date' is a string and it contains date information in this
format: "DEC/05/2007".
Now I am trying to convert the format as "2007-12-05".

Is it possible to convert the arrangement using 'Format' method?
If so, please educate me how I can do such operation.

Thank you!

[Cor Ligthert[MVP]]

Hi Thomas,

This newsgroup is full of the DateTime.ParseE xact method and the overloaded
string to convert a datetime, by using both is should be easy..

Have a look to it or/and search this newsgroup.

http://msdn2.microsoft.com/en-us/lib...ct(VS.71).aspx

http://msdn2.microsoft.com/en-us/library/zdtaw1bw.aspx

Cor

[Phill W.]

th*********@gma il.com wrote:

Variable 'Date' is a string ...

.... which is a /lousy/ name for a String variable, BTW ...
(Hang on! Isn't "Date" [still] a reserved word??)

... and it contains date information in this format:
"DEC/05/2007".
Now I am trying to convert the format as "2007-12-05".

? DateTime.ParseE xact( "MMM/dd/yyyy" ).ToString( "yyyy-MM-dd" )

will work, so long as your in an English or French-speaking Locale; you
/might/ have problems elsewhere in the World.

Is it possible to convert the arrangement using 'Format' method?

Not directly.
Format() will take a DateTime variable and convert it into a String but
it can't take a String (in a non-standard date format) and do anything
useful with it.
Just out of curiosity, where did you get the data in that format
(MMM/dd/yyyy") /from/? I don't think I've ever seen that one before.

HTH,
Phill W.

[=?Utf-8?B?U3VydHVyWg==?=]

A straight string manipulation will do it, if you aren't doing any date
arithmetic.

Just use the Mid() function and translate the month names to a numeral.

If you are doing date arithmetic, then use the DateSerial() function after
converting the month name.

--
David Streeter
Synchrotech Software
Sydney Australia
"th*********@gm ail.com" wrote:

This is regarding VB.NET 2003.

Variable 'Date' is a string and it contains date information in this
format: "DEC/05/2007".
Now I am trying to convert the format as "2007-12-05".

Is it possible to convert the arrangement using 'Format' method?
If so, please educate me how I can do such operation.

Thank you!

[Stephany Young]

DateTime.ParseE xact(StrConv([Date], VbStrConv.Prope rCase), "MMM/dd/yyyy",
CultureInfo.Inv ariantCulture). ToString("yyyy-MM-dd")

Note the use of StrConv([Date], VbStrConv.Prope rCase) to change DEC to Dec,
otherwise the DateTime.ParseE xact won't work correctly.
<th*********@gm ail.comwrote in message
news:94******** *************** ***********@t1g 2000pra.googleg roups.com...

This is regarding VB.NET 2003.

Variable 'Date' is a string and it contains date information in this
format: "DEC/05/2007".
Now I am trying to convert the format as "2007-12-05".

Is it possible to convert the arrangement using 'Format' method?
If so, please educate me how I can do such operation.

Thank you!