converting string to a particular date time format in vb.net

Question

1.00/5 (2 votes)

See more:

Hi All,

This may be a widely asked question with lots of possible solutions but unfortunately none of them is working for me..

I have a string like this:
"02/09/2015 10:00"
which represents
dd/mm/yyyy HH:mm

I have tried using Convert.toDateTime() and DateTime.Parse() There is no error, but it always gives output which says its 09th Feb, 2015 which is not. The time part is alright though.

How can I get correct output?

Thank you....

Posted 2-Sep-15 2:39am

planetz

Add a Solution

Comments

CHill60 2-Sep-15 8:46am

What code are you using to produce the output?

Andy Lanng 2-Sep-15 8:48am

Try DateTime.ParseExact

Ralf Meier 2-Sep-15 8:52am

Have you tried to write it like this : "dd/MM/yyyy HH:mm" instead of "dd/mm/yyyy HH:mm"

Sergey Alexandrovich Kryukov 2-Sep-15 8:55am

What's wrong with reading original MSDN documentation?
—SA

Andy Lanng 2-Sep-15 8:57am

Ha - virtual 5*

Sergey Alexandrovich Kryukov 2-Sep-15 8:59am

Thank you, but I answered the question, too.
—SA

Andy Lanng 2-Sep-15 9:06am

I know - already 5'ed for the answer. This is a whole different comment 5 ^_^

Sergey Alexandrovich Kryukov 2-Sep-15 9:37am

Anyway, thank you for both.
—SA

ZurdoDev 2-Sep-15 8:58am

It shows February 9 but you're expecting September 2? That is due to your Culture settings of the thread executing the code.

F-ES Sitecore 2-Sep-15 9:05am

Post some solutions that aren't working. This is indeed a frequently asked question and if you google you'll find a lot of samples that use DateTime.TryParse. If they are not working for you then post your code so we can see what the issue is.

planetz 3-Sep-15 2:49am

Yes RyanDev...I am expecting September 2...

1 solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2015-09-02T02:55:00

First of all, think at this: can you totally avoid "conversion" (in fact, parsing) strings? This is usually possible, if your learn to work with data, not strings representing data.

To parse correctly, you just need to look at all available DateTime parse methods, not only Parse, but TryParse, ParseExact and TryParseExact. You will see parameters used to specify the culture and/or exact format:
https://msdn.microsoft.com/en-us/library/system.datetime.parse%28v=vs.110%29.aspx[^],
https://msdn.microsoft.com/en-us/library/System.DateTime.TryParse%28v=VS.110%29.aspx[^],
https://msdn.microsoft.com/en-us/library/system.datetime.parseexact%28v=vs.110%29.aspx[^],
https://msdn.microsoft.com/en-us/library/system.datetime.tryparseexact%28v=vs.110%29.aspx[^].

For formats, please see:
https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx[^],
https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx[^].

—SA