error-String was not recognized as a valid DateTime.

Abhilash J A

Hello everyone,

I am getting list of data from datatable with date also.

After I am trying to bind this data to listview, then occurred date format error. Here AccessDate string datatype.

How can I solve this issue? Please help me.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Why not keep AccessDate as DateTime type column?

Always remember, once the date is converted to string, all important information is lost. NEVER covert date time to string. Convert to string ONLY WHEN you are putting it in label,textbox, etc.
Nitin Sontakke9y ago
I guess Chetan has already answered. NEVER EVER store dates as strings. Why did they created DateTime type then?

You can go through all the trouble that you can for now, but change it as soon as you can. Trust me, you will keep on facing issues. Sorting, add, subtract, everything.
Abhilash J A9y ago
Hello Nitin, Chetan Sir,

I have changed AccessDate as Datetime datatype inside DB.

Thanks,
Abhilash.J.A
Chetan Ranpariya9y ago
Any specific reason you designed that way? Is it not possible now to change it to datetime? If code is not gone to production it is good if change now coz it will save lot of time of dealing with this kind of errors. Anyways can you tell us what value you are getting from the db for that column? And how are you saving that to the db?
Abhilash J A9y ago
Yes Nitin Sir,

I have already design sqllite database like that VARCHAR(50) datatype. And now all implemented code are depending upon this datatype format. So... Now, how can solve this issue sir?