'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.ParseExact 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/library/system.datetime.parseexact(VS.71).aspx

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

Cor

 

[Phill W.]

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.ParseExact( "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.

 

[SurturZ]

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.

 

[Stephany Young]

DateTime.ParseExact(StrConv([Date], VbStrConv.ProperCase), "MMM/dd/yyyy",
CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")

Note the use of StrConv([Date], VbStrConv.ProperCase) to change DEC to Dec,
otherwise the DateTime.ParseExact won't work correctly.