Error in converting String to Date time...

• • Reply

  11 years ago

  by chezhian_in05

  chezhian

  chennai, India

  Joined 15 years ago

  I'm trying to convert a string value(19/3/2009) by using Convert.Datetime("19/3/2009",CultureInfo("en-US")); The above given code works good in my System.When i tried to deploy the application.the same code give the below given error

  System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value, IFormatProvider provider) at System.String.System.IConvertible.ToDateTime(IFormatProvider provider) at System.Convert.ToDateTime(Object value, IFormatProvider provider)

  Can anyone suggest me the reason for this

  Report abuse
• • Reply

  11 years ago

  by Slicksim

  Simon Cooper

  Lancaster, United Kingdom

  Joined 15 years ago

  Hi,

  most likely the culture of the system you are installing it to doesn't match yours. it might be set to en-GB or have a different time/date seperator.

  Si

  Report abuse
• • Reply

  11 years ago

  by chezhian_in05

  chezhian

  chennai, India

  Joined 15 years ago

  it still gives the error if i convert this without culture Convert.Datetime("19/3/2009") i need to convert 19/03/2009 to a valid Date time. Can anyone help on this ?

  Report abuse
• • Reply

  11 years ago

  by Slicksim

  Simon Cooper

  Lancaster, United Kingdom

  Joined 15 years ago

  hi,

  you could try date.parseexact, but again, i have had mixed results with this, i ended up writing this routine to convert my dates, it has only failed me once so far.

  Public Shared Function MangleDate(ByVal TheDate As String) As Date        
          Dim strSystemFormat As String = System.Threading.Thread.CurrentThread.CurrentUICulture.DateTimeFormat.ShortDatePattern
          Dim strDay As String = TheDate.Substring(0, 2)
          Dim strMonth As String = TheDate.Substring(3, 2)
          Dim strYear As String = TheDate.Substring(6, 4)
          strSystemFormat = strSystemFormat.Replace("dd", strDay)
          strSystemFormat = strSystemFormat.Replace("MM", strMonth)
          strSystemFormat = strSystemFormat.Replace("yyyy", strYear)
          Return Date.Parse(strSystemFormat, Nothing, DateTimeStyles.AssumeLocal)
      End Function
  

  Try it and see how it goes for you

  Si

  Report abuse
• • Reply

  11 years ago

  by chezhian_in05

  chezhian

  chennai, India

  Joined 15 years ago

  Perfect it worked good

  Report abuse
• • Reply

  11 years ago

  by gmdarsh

  gm darshan

  , India

  Joined 13 years ago

  Hi all ,

  This Code might solve your issue .

  CultureInfo provider = CultureInfo.InvariantCulture ;

  string dateTime = "20090303115521";

  string format = "yyyyMMddhhmmss";

  DateTime dtdateTime;

  dtdateTime = DateTime.ParseExact( dateTime, format, provider );

  Report abuse
• • Reply

  11 years ago

  by chezhian_in05

  chezhian

  chennai, India

  Joined 15 years ago

  Hi all.. thanks for taking time to reply my post.. i found out the solution by setting thread culture. which resulted.

  Report abuse