convert string to valid datetime

Question

0.00/5 (No votes)

See more:

ASP.NET

hi,

how to convert this string " 1-Jan-2014 at 16:18 " to valid date time

Posted 23-Jul-14 19:50pm

sadhana4

Add a Solution

3 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)

Sharmanuj · Answer 1 · 2014-07-23T19:59:00

Solution 1

Hi Sadhana,

Please see the below links for string to datetime conversion. Hope this will help you.

Easy String to DateTime, DateTime to String and Formatting[^]

http://msdn.microsoft.com/en-IN/library/cc165448.aspx[^]

Posted 23-Jul-14 19:59pm

Sharmanuj

Comments

sadhana4 24-Jul-14 2:18am

i m trying converting my date example
BASICDATETIMEOFINVOICE = "1-Jan-2014";

DateTime date;
date = new DateTime();
date = DateTime.ParseExact(BASICDATETIMEOFINVOICE, "dd-MM-yyyy", null);

but it is given error
String was not recognized as a valid DateTime.

sadhana4 24-Jul-14 2:19am

why

Sharmanuj 24-Jul-14 3:00am

Hi Sadhna,

please see the below solution provided.

Thanks7872 · Answer 2 · 2014-07-23T20:43:00

Solution 2

Let me answer your comment first. For that modify code like this:

C#

BASICDATETIMEOFINVOICE = "1-Jan-2014";
DateTime date = DateTime.ParseExact(BASICDATETIMEOFINVOICE, "d-MMM-yyyy", CultureInfo.InvariantCulture);

And for your question,code should go like this:

C#

DateTime date =DateTime.ParseExact("1-Jan-2014 16:18","d-MMM-yyyy HH:mm",CultureInfo.InvariantCulture);

Important to refer : http://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx[^]

Regards..

Posted 23-Jul-14 20:43pm

Thanks7872

v2

Comments

sadhana4 30-Jul-14 1:47am

i put this :
BASICDATETIMEOFINVOICE = "1-Mar-2014";
DateTime date = DateTime.ParseExact(BASICDATETIMEOFINVOICE, "d-MMM-yyyy", CultureInfo.InvariantCulture);

date = "3/1/2014 12:00:00 AM"
month is coming first and date is second

Thanks7872 30-Jul-14 1:51am

date is of type DateTime which doesn't have any format. To get it in required format you can use .ToString("Your required format");.

sadhana4 30-Jul-14 1:56am

it is working find
i convert date.ToString("yyyy/MM/dd");
so it is showing correct

Thanks7872 30-Jul-14 2:02am

Its always good to accept answers that worked for you so in future some one facing same issue may come to know.

Sharmanuj · Answer 3 · 2014-07-23T20:43:00

Solution 3

Use this code

string myDate = "02-Mar-2014";
DateTime myDateTime;
myDateTime = Convert.ToDateTime(myDate);
string newDate = myDateTime.ToString("mm/yyyy/dd");
MessageBox.Show(newDate);

Posted 23-Jul-14 20:43pm

Sharmanuj

Comments

Thanks7872 24-Jul-14 2:44am

Don't repost solutions. Update your first solution.Remove this.