Code fails when date in the format dd/mm/yyyy is given instead of date time

Question

1.00/5 (1 vote)

See more:

C#

DateTime.ParseExact(value[54].Trim(), "d/M/yyyy", CultureInfo.InvariantCulture);

the code fails when date in the format dd/mm/yyyy is given instead of date time.

Any one faced this issue before?

What I have tried:

C#

DateTime.ParseExact(value[54].Trim(), "d/M/yyyy", CultureInfo.InvariantCulture);

Posted 15-Feb-16 19:59pm

spriyanair

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)

*dan!sh* · Answer 1 · 2016-02-15T20:08:00

Solution 1

You date format string is not accurate. Take a look at this[^] page for format strings.

In order to cater for multiple date formats, you should go for TryParseExact. It accepts an array of strings for different formats.

Posted 15-Feb-16 20:08pm

dan!sh

Updated 15-Feb-16 21:39pm

v2

Comments

spriyanair 16-Feb-16 2:15am

DateTime.ParseExact(value[21].Trim(), "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); I have used this code before its working fine if string is date time.But it fails when date alone is given.Could you clarify with an example

dan!sh 16-Feb-16 2:18am

Do not provide HH:mm:ss if it is not in the string value.

spriyanair 16-Feb-16 2:20am

some data have time stamp some don't have; have to work in both the cases

dan!sh 16-Feb-16 3:40am

Updated the response.

koolprasad2003 · Answer 2 · 2016-02-15T20:15:00

Solution 2

Use 'ParseExact' method of 'DateTime' class with 'dd/MM/yyyy' format, it also work for 'd/M/yyyy'.
see below snippet

C#

string dt = "24/12/2010";
DateTime dt1;
//always use InvariantCulture for dateformat provider as it support large number of customized datetime formats
System.Globalization.CultureInfo provider = System.Globalization.CultureInfo.InvariantCulture;
dt1 = DateTime.ParseExact(dt, "dd/MM/yyyy", provider);
MessageBox.Show("String successfully converted to DateTime" + dt1.Year);

Hope it helps
for more detail see this[^]

Posted 15-Feb-16 20:15pm

koolprasad2003

Comments

spriyanair 16-Feb-16 2:54am

what happens if string is in date time format

koolprasad2003 16-Feb-16 3:49am

Just convert the format to hh:MM:ss
dt1 = DateTime.ParseExact(dt, "dd/MM/yyyy hh:MM:ss", provider);

spriyanair 16-Feb-16 3:59am

I id like that only it work fine when date with time stamp is given but will fails when date alone is given

koolprasad2003 16-Feb-16 4:06am

what error you faced ? exception message ?

F-ES Sitecore · Answer 3 · 2016-02-15T22:55:00

Solution 3

As suggested, use TryParseExact and pass it a list of formats you accept, then add some code that handles when the string isn't in a format you accept.

DateTime.TryParseExact Method (String, String[], IFormatProvider, DateTimeStyles, DateTime) (System)[^]

Posted 15-Feb-16 22:55pm

F-ES Sitecore