Error while converting string to Datetime

Question

I have string value 7/29/2000. When I convert it to date time it's giving an error. Error Message: Cannot convert string to Datetime

IFormatProvider provider = new System.Globalization.CultureInfo("en-US", true);
string oldValue = decrypt.Decrypt(dtOldI9Value.Rows[0][column.ColumnName].ToString().Trim());
DateTime dtOldValue = DateTime.Parse(oldValue, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);

From the 3 rd line i am getting the value as "7/29/2000". Please help me.

what does decrypt do ? Have you stepped into line 3 to see what's actually inside oldValue ? — marc wellman
– marc wellman, Commented Jul 3, 2012 at 12:07
Put a break point on third line and see what is inside oldValue — Habib
– Habib, Commented Jul 3, 2012 at 12:07
Try to log dtOldI9Value.Rows[0][column.ColumnName].ToString().Trim() to see if the date is well formatted — anouar.bagari
– anouar.bagari, Commented Jul 3, 2012 at 12:12

CodeCaster · Accepted Answer · 2012-07-03 12:09:00Z

3

This works:

IFormatProvider provider = new System.Globalization.CultureInfo("en-US", true);
DateTime dtOldValue = DateTime.Parse("07/29/2000", provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
Console.WriteLine(dtOldValue);

So there must be something with your decrypt.Decrypt(). Are you sure it doesn't adds characters to oldValue? Check oldValue.Length, it should be 10.

answered Jul 3, 2012 at 12:09

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Onots Over a year ago

+1 for the lenght check. With a method called decrypt, is there a possibility for none-displayable characters in the string?

Joby Kurian Over a year ago

Actual value is "7/29/2000" with 9 length

Collectives™ on Stack Overflow

Error while converting string to Datetime

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related