Please help String was not recognized as a valid DateTime ERR?

Question

0.00/5 (No votes)

See more:

System.FormatException: String was not recognized as a valid DateTime.

Source Error:
Line 58: apptime.SlotTime = DateTime.ParseExact(tempdatetime, "dd/MM/yyyy HH:mm:ss tt", culture);

"But it's work when i copy this code to to my local system" ,Error occurred while I running this application from server...pls help me

Posted 31-Mar-14 21:56pm

Kan07

Add a Solution

Comments

Richard MacCutchan 1-Apr-14 4:05am

What is the content of the string in tempdatetime?

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)

Peter Leow · Answer 1 · 2014-03-31T22:39:00

You should use TryParseExact to check the validity of the tempdatetime value, see example:

C#

using System;
using System.Globalization;

public class Program
{
    public static void Main()
    {

        string tempdatetime = "01/04/2014 01:00:00 AM";
        string format = "dd/MM/yyyy HH:mm:ss tt";
        DateTime dateTime;
        if (DateTime.TryParseExact(tempdatetime, format, CultureInfo.InvariantCulture,
        DateTimeStyles.None, out dateTime))
        {
            Console.WriteLine(dateTime);

        }
        else
        {
            Console.WriteLine("Not a valid date time");
        }
    }
}

OriginalGriff · Answer 2 · 2014-03-31T22:21:00

You are telling the system exactly what format to expect, and the data supplied is not in that format.
Now, there are two possibilities here: firstly that the string is not in "dd/MM/yyyy HH:mm:ss tt" format - it may be entered as "1/04/2014 08:09:10 AM" which doesn't exactly match because the "dd" part has only been provided with a single digit.

The second is that the culture is wrong: It is quite possible that you are expecting a culture that matches that on your development machine, and the production server is configured very differently. This could cause the same problem, but is a lot less likely.

Start with the string: look at lit and see exactly what you are trying to convert - then look at where it comes from!

Raul Iloc · Answer 3 · 2014-03-31T22:22:00

1.When you are running your application into an running environment, like a web server, or the data comes from a database server, the "current culture info" of that running environment is used and this could be different then your local computer.

2. Because of the running environment, in your case the value from tempdatetime is not in the format that your are trying to convert (maybe the date is in English format like: "mm/dd/yyyy...").

3.If you know directly or indirectly (by using configuration parameter) the "current culture info" of your running environment you should modify your code by first creating the DateTime object from string by using the culture info of your running environment (by using DateTime.Parse(tempdatetime, serverCultureInfo); ), and then convert the resulted DateTime into your custom format.

Please help String was not recognized as a valid DateTime ERR?

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0