calculate difference between two dates using c#

Question

I'm trying to calculate difference between two dates, my code is given below

DateTime daterenew = DateTime.Parse(drow.ItemArray.GetValue(16).ToString()); //18/01/2017
        DateTime datecurrent = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyyy"));
        renewstatuslbl.Text = ((daterenew - datecurrent).Days) + " Day(s) remains";

But I'm getting an error

"String was not recognized as a valid DateTime."

you can change this line `DateTime datecurrent = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyyy"));` to `DateTime datecurrent = DateTime.Now;` you do not need to parse it again — NtFreX, Sep 08 '16 at 07:04
Possible duplicate of [Datediff getting the date inbetween 2 dates and bind it to a gridview](http://stackoverflow.com/questions/6057377/datediff-getting-the-date-inbetween-2-dates-and-bind-it-to-a-gridview) — VDWWD, Sep 08 '16 at 07:06
Possible duplicate of [Calculate difference between two dates (number of days)?](http://stackoverflow.com/questions/1607336/calculate-difference-between-two-dates-number-of-days) — Liam, Sep 08 '16 at 07:07
Possible duplicate of [String was not recognized as a valid DateTime " format dd/MM/yyyy"](http://stackoverflow.com/questions/2193012/string-was-not-recognized-as-a-valid-datetime-format-dd-mm-yyyy) — Divyang Desai, Sep 08 '16 at 07:07
As shown, your problem isn't actually anything to do with calculating the difference between two dates - it's parsing a date in the first place. It's not at all clear to me why your second line isn't just `DateTime today = DateTime.Today;` though. You should avoid string conversions unless they're *really* what your code is trying to achieve, which it isn't here... — Jon Skeet, Sep 08 '16 at 07:08

Bob · Answer 1 · 2016-09-08T07:16:24.497

Assuming your drow.ItemArray.GetValue(16).ToString()format is always dd/MM/yyyy. Use ParseExact

        DateTime daterenew = DateTime.ParseExact(drow.ItemArray.GetValue(16).ToString(), "dd/MM/yyyy", null); //18/01/2017
        //DateTime datecurrent = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyyy"));
        DateTime datecurrent = DateTime.Now;
        renewstatuslbl.Text = ((daterenew - datecurrent).Days) + " Day(s) remains";

score 0 · Answer 2 · edited Sep 08 '16 at 07:10

0

I would simplify that:

var daterenew = DateTime.ParseExact("18/01/2017", "dd/MM/yyyy", CultureInfo.InvariantCulture);
var res = ((daterenew - DateTime.Today).Days) + " Day(s) remains";

Note, that DateTime.Now != DateTime.Today.

edited Sep 08 '16 at 07:10

Liam

27,717
28
128
190

answered Sep 08 '16 at 07:09

Paweł Dyl

8,888
1
11
27

score 0 · Answer 3 · edited Sep 08 '16 at 08:45

The format of the date , causes the error. 18/01/2017 https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx

example I used "yyyy/MM/dd"

//DateTime daterenew = DateTime.Parse("18/01/2017"); //18/01/2017
DateTime daterenew = DateTime.Parse("2017.01.18"); //18/01/2017
DateTime datecurrent = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyyy"));
object renewstatuslbl = ((daterenew - datecurrent).Days) + " Day(s) remains";

thus, I think you can change the string date format first of the value before inserting to drow.ItemArray

score 0 · Answer 4 · answered Sep 08 '16 at 07:10

0

Try something like this

string dateString = drow.ItemArray.GetValue(16).ToString();
DateTime daterenew = DateTime.ParseExact(dateString, "dd/MM/yyyy", CultureInfo.InvariantCulture); 

renewstatuslbl.Text = string.Format("{0} Day(s) remains", (daterenew - DateTime.Now).TotalDays);

Idea is in ParseExact where you can set up format for your date in drow.ItemArray Also look at TotalDays

answered Sep 08 '16 at 07:10

Anatoli Klamer

2,279
2
17
22

#zxxc I solved my problem. You need to change .TotalDays to .Days else results will look like this 132.00:00:00. Thanks – Ravinder Godara Sep 08 '16 at 07:20

score 0 · Answer 5 · answered May 23 '22 at 05:29

enter codenamespace FineCalculation

{ public partial class Form1 : Form { public Form1() { InitializeComponent(); }

    private void button1_Click(object sender, EventArgs e)
    {
        DateTime date01 = date1.Value;
        DateTime date02 = date2.Value;

        TimeSpan timeSpan = date02 - date01;

        int days = Convert.ToInt16(timeSpan.TotalDays);

        double fine = 0;

        if(days < 30)
        {
            fine = days * 0.5;
        }else if(days > 30 && days < 60)
        {
            fine = days * 0.5 * 0.75;
        }else if(days > 60)
        {
            fine = days * 0.5 * 0.75 * 1;
        }


        MessageBox.Show("For "+ days + " days fine is " + fine.ToString());
    }
}

} here

This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). - [From Review](/review/late-answers/31839672) — Valerij Dobler, May 28 '22 at 19:44

calculate difference between two dates using c#

5 Answers5