String was not recognized as a valid DateTime

Renjith V S

12y2.8k.NET

Hi,
On running my project at the first time in Visual Studio 2012 all the values I have entered will be inserted to database and the save process will be success. But after first run I could not run the same code, it shows an error message "String was not recognized as a valid DateTime".
Please help me

12 Replies

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

Anupam Singh12y ago
:) all well if ends well.
Renjith V S12y ago
Hi Anupam,
I have got the solution for my problem. Its the date picker date format problem. I have used a date picker plugin for adding calender in the text box. Its default format is MM/dd/yyyy. But I need to pass the date in the dd/MM/yyyy format. So I need to change the format there by using the below code.
$("#txtAddedDate").datepicker({dateformat : "dd/mm/yyyy"});

Thanks for the Support Anupam.
Anupam Singh12y ago
Okey,
Seems time is not being consider.
go to the article here
written by mahesh sir. and I am sure you wont need more help in this.
Renjith V S12y ago
Hi Anupam,
Its the problem of date format in some function it is mm/dd/yyyy format and in somewhere its in dd/mm/yyyy format. I need to change the format to same for all places.

Abhay Shanker12y ago

Not sure, but check with this.

DateTime date = DateTime.ParseExact(this.Text, AddedDate, CultureInfo.InvariantCulture);

objInfoBO.AddedDate = date ;

Also check date format in string

Renjith V S12y ago
Hi Anupam,
I am saving this time in my table details column name AddedDate and it is declared as datetime. In my project I am using JSON to pass the values. In my aspx page I declared variable using JSON and in aspx.cs page I have used parameter string AddedDate and the value will be get as
"objInfoBO.AddedDate = Convert.ToDateTime(AddedDate); ".
Renjith V S12y ago
Hi Abhay,
In my project I have used a parameter as string AddedDate and I am using a table details, this table include AddedDate and other columns. I am using JSON to pass the value entered in the text box AddedDate and it will be stored in the SQL database as well. But when ever I tried today's date or 2 days before today, it will show the described error.
Anupam Singh12y ago
It depends where do you save this datetime in sql or somewhere else. share some date sample sample . or if you can share code. then it will more clear.
Renjith V S12y ago
Hi Anupam,
Can you please explain the solution. If I use nearby date of today the error will be occured otherwise its fine.
Anupam Singh12y ago
Hi Renjith,

It may be because of Globalization .Because I have faced the same issue a long time back that I was using different culture(settings).
Abhay Shanker12y ago
Please share more information like your table structure your SP and the code block you are getting error.
Renjith V S12y ago
Whenever I try date which is less than today's date will works fine. I wonder the reason