Datetime help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AVL - 12 Feb 2008 11:54 GMT

Hi,
I've need some info regarding datetime conversions..
I've a string in the below format'"dd/mm/yyyy"..I want it to be converted to
Datetime object with the date format as "mm/dd/yyyy"
I've used the below code..

Dim provider As IFormatProvider
provider = New System.Globalization.CultureInfo("en-US", True)
drnewRow("Inv_Date_Detail") = DateTime.ParseExact("21/11/2007",
"dd/MM/yyyy", provider).ToShortDateString()

This workds fine if my current culture in regional settings is "en-US"..
but fails when I move my current culture to 'en-GB"..

I want a generic solution to this..
how shud i convert a "dd/mm/yyyy" to "mm/dd/yyyy" in vb/net?

Reply to this Message

Mark Rae [MVP] - 12 Feb 2008 11:59 GMT

> I want a generic solution to this..
> how should i convert a "dd/mm/yyyy" to "mm/dd/yyyy" in vb/net?

Try this:
drnewRow("Inv_Date_Detail") = DateTime.ParseExact("21/11/2007",
"dd/MM/yyyy", Nothing).ToShortDateString()

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...