DateTime error on c#

Question

3.00/5 (2 votes)

See more:

String was not recognized as a valid DateTime.Couldn't store <25/12/2013> in ClosingDate Column. Expected type is DateTime.

If i give the date less than 12 means 11/12/2013 then it works fine but if i give it greater than 12 means 25/12/2013 the it gives this error.Why is this error coming?

C#

private int _id;

    private DateTime _ClosingDate;
    public DateTime ClosingDate
    {
        get
        {
            return _ClosingDate;
        }
        set
        {
           _ClosingDate = value;
        }
    }


private List<PotentialEntity> fetchrecords(DataTable FTable)
        {
            List<PotentialEntity> Entity = new List<PotentialEntity>();
            foreach (DataRow oRow in FTable.Rows)
            {
                PotentialEntity pEntity = new PotentialEntity();                
                pEntity.ClosingDate =(DateTime)(oRow["ClosingDate"]);                
                Entity.Add(pEntity);
            }
            return Entity;
        }

GridView1.DataSource = Entity;
        GridView1.DataBind()

ASP.NET

<asp:TemplateField HeaderStyle-Width="100px" HeaderStyle-ForeColor="White" meta:resourcekey="TemplateFieldResource5">
            <itemtemplate>
                <asp:Label ID="lblClosingDate" runat="server" Text='<%# Eval("ClosingDate").ToString().Substring(0,10) %>'
                    meta:resourcekey="lblClosingDateResource1"/></itemtemplate>
            <HeaderStyle Width="100px" />

Posted 27-Dec-13 21:23pm

Sumit Bhargav

Updated 29-Dec-13 21:15pm

Aarti Meswania

v7

Add a Solution

Comments

Aydin Homay 28-Dec-13 3:25am

Please explain your problem, Do you want convert String to DateTime ?

Sumit Bhargav 28-Dec-13 3:29am

Exactly,I am trying to save a string of date "28/12/2013" into a datetime data type in sql table
via stored procedure expecting a datetime variable.I tried many ways but whenever i try to save the days of a date greater than 12 it throw me that error.What could be the possible reason?

Aydin Homay 28-Dec-13 3:50am

Why you don`t use nvarchar data type ? it can make good facilities in implementation and you can handle data converting string to date time in the application layer.

Sumit Bhargav 28-Dec-13 3:55am

Hi aydin,
The question was for converting string to datetime not for datetime to nvarchar.

Richard MacCutchan 28-Dec-13 4:38am

Do not use strings to save dates in a database.

Sumit Bhargav 28-Dec-13 5:00am

so how to do it?

Richard MacCutchan 28-Dec-13 5:22am

Convert it to a DateTime value using one of the Parse or TryParse methods. You have not shown the code you are using, so it is difficult to suggest anything more useful.

7 solutions

Solution 2

Hi
Please follow of this link:

How to: Convert a String to a DateTime (C# Programming Guide)
Converting String to DateTime C#.net

Best Regards.

Posted 27-Dec-13 22:01pm

Aydin Homay

Solution 1

try

string Date="28/12/2013";
DateTime Dt = DateTime.Now(); 
DateTime.TryParse(string,out Dt);

Posted 27-Dec-13 21:29pm

agent_kruger

Solution 3

C#

string value = oRow["ClosingDate"] + "";
       // keep a break point and check the value, in which format the value appears
       // based on the format you can change the format value
       string format = "MM/dd/yyyy";
      var datetime =  DateTime.ParseExact(value,format,System.Globalization.CultureInfo.InvariantCulture );

Reference:
Date Time casting..[^]

Posted 29-Dec-13 21:54pm

Karthik_Mahalingam

Comments

Sumit Bhargav 30-Dec-13 4:40am

the datetime format of the string is 30/12/2013 12:00:00
What will be the format now?

Karthik_Mahalingam 30-Dec-13 4:48am

"dd/MM/yyyy hh:mm:ss"

Sumit Bhargav 30-Dec-13 5:38am

i did this but it says string is not a valid datetime

Karthik_Mahalingam 30-Dec-13 5:42am

"30/12/2013 12:00:00 "
to
"30/12/2013 12:00:00"
remove empty space at the end..

Sumit Bhargav 30-Dec-13 6:13am

hi karthik,
i tried as per you said,still it gives the same error

Sumit Bhargav 30-Dec-13 6:15am

I am converting the datetime column to fetch only date in sql like this-
Convert(varchar(10),columnname,103) but still it shows the 30/12/2013 12:00:00 in
the datatable in c# ,i dont understand y it shows the time ?

Karthik_Mahalingam 30-Dec-13 7:51am

datetime object will show the time also..

what do you need exactly ?

Sumit Bhargav 30-Dec-13 8:02am

I am binding the DateTime column of sql in gridview and while binding it shows that error.If the date is below 12 then it works fine but if the date is greater than 12 than it throw that error.

Karthik_Mahalingam 30-Dec-13 8:25am

"MM/dd/yyyy hh:mm:ss"
try this

Solution 4

I guess that you have american date culture. Therefore 28/12/2013 is 12th day, 28th month. Clearly such a date doesnt exist so it throws an exception. Try to change the string to 12/28/2013 to be sure this is not the problem. TryParse or Parse is the way as was already said...

Posted 30-Dec-13 4:33am

Igor Spitz

Solution 5

this is because it is displaying in "MM/dd/yyyy" not in "dd/MM/yyyy".

try

((DateTime)(oRow["ClosingDate"])).ToString("dd/MM/yyyy")

this will change it to dd/MM/yyyy format

Posted 30-Dec-13 5:51am

agent_kruger

Solution 6

Further to the other solutions, you can avoid issues with dates and localised presentations of dates by always using ISO 8601 ("International") format dates yyyy-mm-dd - see http://en.wikipedia.org/wiki/ISO_8601[^]

Another method is to use the unambiguous date format "dd-MMM-yyyy" e.g. "25-DEC-2013" - most databases will accept this input.

Posted 31-Dec-13 2:23am

CHill60

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)

Sumit Bhargav · Accepted Answer · 2013-12-31T02:40:00

Solution 7

I still don't understand the solution of this problem but it has been resolved.
In the database i was fetching the records while converting the date in the format like this
convert(varchar(10),datecolumn,103) but when i change this to convert(varchar(10),datecolumn,110) it starts working,now it's working fine but i still don't get this y it wasn't working when i was
taking the format of 103.
I humbly thanks to all those who helped me in resolving this issue.

Posted 31-Dec-13 2:40am

Sumit Bhargav

Comments

CHill60 31-Dec-13 8:51am

Convert style 103 is UK style dd/mm/yyyy whereas 110 is US format mm-dd-yyyy. If you retrieved the original date from the database with style 103 and stored it into a string in your program then the string would have held the date in the wrong format. See my solution (6) below for a better approach. It is also better to use the correct data type throughout.

Member 11665191 5-May-15 4:59am

This solution worked for me too.