Conversion of string to date time in c# asp.net

Question

0.00/5 (No votes)

See more:

i am getting date time in string format(dd/mm/yyyy). I want to convert to it in to datetime. So i tried bellow methods which failed. So please help me regarding this issue.

C#

//datetime in string format from client

string mindate = 15/06/2013 11:03:24
 //now i am converting above to DateTime

DateTime MinDateTime = Conevrt.ToDateTime(mintime)//getting error Message = "String was not recognized as a valid DateTime."

// another conversion

DaTeTime MinDateTime = DateTime.ParseExact(mintime)//getting error Message = "String was not recognized as a valid DateTime."

// another conversion


DaTeTime MinDateTime = DateTime.Parse(mintime)//getting error Message = "String was not recognized as a valid DateTime."

so please help me regarding the conevrsions. Thank You.

Posted 20-Jun-13 21:52pm

kalyan10qwerty

Updated 20-Jun-13 21:53pm

Prasad_Kulkarni

v2

Add a Solution

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ArunRajendra · Answer 1 · 2013-06-20T22:07:00

Solution 2

The problem is with the data. It is considering mm/dd/yyyy format instead of dd/mm/yyyy. Try to swap the month and day part in your mindate variable.

Posted 20-Jun-13 22:07pm

ArunRajendra

Updated 20-Jun-13 22:08pm

v2

Bilashcse · Answer 2 · 2013-06-21T12:24:00

Check this :

C#

string[] dateStrings = {"2008-05-01T07:34:42-5:00",
                        "2008-05-01 7:34:42Z",
                        "Thu, 01 May 2008 07:34:42 GMT"};
foreach (string dateString in dateStrings)
{
   DateTime convertedDate = DateTime.Parse(dateString);
   Console.WriteLine("Converted {0} to {1} time {2}.",
                     dateString,
                     convertedDate.Kind.ToString(),
                     convertedDate);
}

Md.Sajidur rahman · Answer 3 · 2013-06-20T21:56:00

Solution 1

Try It i think you can get your solutions.

Convert.ToDateTime(mindate).ToString("dd'.'MM'.'yyyy")

Thanks

Posted 20-Jun-13 21:56pm

Md.Sajidur rahman

Updated 20-Jun-13 22:01pm

v2

Mukesh Ghosh · Answer 4 · 2013-06-20T22:10:00

use this

string dateString = "15/06/2008 08:30";
string format = "g";
CultureInfo provider = new CultureInfo("fr-FR");

DateTime result = DateTime.ParseExact(dateString, format, provider);

Use using System.Globalization; top of the page.
Also instead og g you can use
DateTime result = DateTime.ParseExact(dateString, "dd/MM/yyyy HH:mm", provider);

Nripendra Ojha · Answer 5 · 2013-06-20T22:12:00

Solution 4

C#

string mindate = 15/06/2013 11:03:24;
string dateformat = "MMMM-dd-yyyy hh:mm:ss";
DateTime.Parse(mindate.ToString(dateformat));

Posted 20-Jun-13 22:12pm

Nripendra Ojha

Updated 20-Jun-13 22:15pm

v2

Comments

kalyan10qwerty 21-Jun-13 4:23am

string mindate = 15/06/2013 11:03:24
string DformatMin = "dd/mm/yyyy HH:mm:ss";
datetime kd1 = DateTime.Parse(mindate.tostring(DformatMin));
Error 1 The best overloaded method match for 'System.DateTime.Parse(string, System.IFormatProvider)' has some invalid arguments

Nripendra Ojha 21-Jun-13 4:34am

Nripendra Ojha - 7 mins ago
string DformatMin = "dd/mm/yyyy HH:mm:ss"; please use capital M not small string DformatMin = "dd/MMMM/yyyy HH:mm:ss";

please inform me. if it will not run or run.

kalyan10qwerty 21-Jun-13 4:43am

string DformatMin = "dd/MMMM/yyyy HH:mm:ss";

DateTime kd1 = DateTime.Parse(Mintime.ToString(DformatMin));

It is showing same error.

Nripendra Ojha 21-Jun-13 4:49am

string DformatMin = "dd/MMMM/yyyy HH:mm:ss";
there is again a small mistake in DformatMIn. You use capital H. i am also not notice that sorry for that. for ur knowledge know the meaning of

dd small d is for day
MM capital M for month
yy small y for year

hh small h for hour
mm small m for minute
ss small s for second

please use this code

string DformatMin = "dd/MMMM/yyyy hh:mm:ss";
DATETIME kd1 = DateTime.Parse(Mintime.ToString(DformatMin));

kalyan10qwerty 21-Jun-13 4:56am

I have changed capital H to small h but again the same result.Please help meeeeee

Nripendra Ojha 21-Jun-13 5:03am

please wait few min..

kalyan10qwerty 21-Jun-13 5:05am

ok thank you for your valuable response

Nripendra Ojha 21-Jun-13 5:31am

please first use this

string mindate = "15/06/2013 11:03:24";
DateTime kd1 = DateTime.Parse(mindate);

if it not work then use this

string DformatMin = "dd/MMMM/yyyy hh:mm:ss";
string mindate = "15/06/2013 11:03:24";
DateTime kd1 = DateTime.Parse(mindate);
kd1 =DateTime.Parse(kd1.ToString(DformatMin));

In my project both are running... Give me details of error if error come.

kalyan10qwerty 21-Jun-13 5:52am

Error 2 Argument '1': cannot convert from 'string' to 'System.IFormatProvider'

Nripendra Ojha 21-Jun-13 6:14am

when that was error come, with which line of code.

kalyan10qwerty 21-Jun-13 6:30am

DateTime kd1 = DateTime.Parse(Mintime.ToString(DformatMin));

for the above line

Nripendra Ojha 21-Jun-13 6:55am

Oh my god, u r still facing problem. may u tell me from where u get the value of time for mindate like client system or from server then you please directly store that time in datetime kd1 like

string DformatMin = "dd/MMMM/yyyy hh:mm:ss";
DateTime kd1 =DateTime.Parse(DateTime.Now.ToString(DformatMin));
TextBox1.Text = kd1.ToLongDateString();

or
DateTime kd1 = DateTime.Now;
TextBox1.Text = kd1.ToLongDateString();

kalyan10qwerty 21-Jun-13 6:59am

that is comming from client side.

Nripendra Ojha 21-Jun-13 7:07am

Then it's my suggestion dear, please never store the value of time in string, use datetime variable every where, every where means every where in client side and server side also. Then i can say no this type of error never will be come. It is wrong technique, u pass the value of time in string. store time in datetime variable and pass that variable.

kalyan10qwerty 21-Jun-13 7:11am

ya but now if i change datatype to datetime it wont accept as previous values are stored in string format so i am trying it in code behind..

Nripendra Ojha 21-Jun-13 7:41am

ok..please pass the value of time in long format at least. like

string mindate = "15/June/2013 11:03:24";
DateTime kd1 = DateTime.Parse(mindate);

then it will must run.

Nripendra Ojha 21-Jun-13 7:49am

Now i will reply u tomorrow, my office time over, i am going to home. Your problem is come due to wrong datatype. it is not big issue or may be, but i know u will must solve it. all the best.

kalyan10qwerty 21-Jun-13 8:03am

ok thanq. plz rply 2maroo

samadhan_kshirsagar · Answer 6 · 2013-06-20T22:23:00

Solution 5

hi visit this link
http://stackoverflow.com/questions/1989342/convert-string-to-datetime-using-c-sharp[^]

Posted 20-Jun-13 22:23pm

samadhan_kshirsagar

Rish_lp · Answer 7 · 2013-06-20T22:57:00

The Problem is with system culture.
it is following US-EN culture.
If you pass your string in "mm/dd/yyyy Time" instead of "dd/mm/yyy Time", it will work.
if your string in not coming in US-EN format. then you have to override the default culture and set it to you culture.
Below link can of your help
String was not recognized as a valid DateTime.[^]