How to get differences of dates

Question

I am making a web page in that I have used Ajax calendar to pick two date like TO date and From date and I also have a Textbox of total days.

So when user selects to and from dates, the difference of these dates is displayed in the textbox. So how can I find the difference of these dates..?

I set the format like dd/MM/yyyy.

e.g.

one textbox has: 20/04/2012  
second has     : 02/05/2012

So, please find difference on these ?

Thanks in Advance....
Mitesh

Please check my removal of AJAX tag (assuming you want to do it server side as tagged with C#). If you need it browser side - add JavaScript tag and possible ajax. — Alexei Levenkov, Jul 02 '12 at 05:58
yes when to date is select and then from_date is select, direct diff. is displayed in next textbox of total days. i want to do at sever side. — Mitesh Machhi, Jul 02 '12 at 06:00
possible duplicate of [How do I get the number of days between two dates in jQuery?](http://stackoverflow.com/questions/542938/how-do-i-get-the-number-of-days-between-two-dates-in-jquery) — V4Vendetta, Jul 02 '12 at 06:04

Nikhil Agrawal · Accepted Answer · 2012-07-02T06:02:24.840

Substraction operator (-) works on DateTime

DateTime to_datetime = DateTime.ParseExact(to_textbox.Text, "dd/MM/yyyy", 
                                           CultureInfo.InvariantCulture);
DateTime from_datetime = DateTime.ParseExact(from_textbox.Text, "dd/MM/yyyy", 
                                             CultureInfo.InvariantCulture);

Timespan result  = to_datetime - from_datetime;

You can use it as

textBox1.Text = (to_datetime - from_datetime).TotalDays.ToString();

Habib · Answer 2 · 2012-07-02T06:00:58.413

3

Convert your textbox values to date using:

DateTime dt1 = DateTime.ParseExact(textbox1.Text, "d/M/yyyy", CultureInfo.InvariantCulture);
DateTime dt2 = DateTime.ParseExact(textbox2.Text, "d/M/yyyy", CultureInfo.InvariantCulture);

Use TimeSpane

    TimeSpan ts = dt1.Subtract(dt2);
    Console.Write(ts.TotalDays);
    textBox3.Text = ts.TotalDays;

edited Jul 02 '12 at 06:00

answered Jul 02 '12 at 05:55

Habib

219,104
29
407
436

score 1 · Answer 3 · answered Jul 02 '12 at 06:00

1

Assuming C# code: DateTime support "-" that results in TimeSpan object.

DateTime nowTime = DateTime.Now;
DateTime yesterday = nowTime.AddDay(-1);
TimeSpan diff = nowTime - yesterday;

answered Jul 02 '12 at 06:00

Alexei Levenkov

98,904
14
127
179

Satinder singh · Answer 4 · 2012-07-16T05:58:18.240

0

DateTime date1 =DateTime.ParseExact("20/04/2012","d/M/yyyy",null);
 DateTime date2 = DateTime.ParseExact("02/05/2012", "d/M/yyyy", null); 
 TimeSpan datediff = date2 - date1;
 Response.Write(datediff.ToString());

edited Jul 16 '12 at 05:58

answered Jul 02 '12 at 06:16

Satinder singh

10,100
16
60
102

How to get differences of dates

4 Answers4