How to operate arithmetic operation on dates?

Question

0.00/5 (No votes)

See more:

.NET3.5

I am making window application using C#.NET and SQL SERVER.I Have two labels in a form for dates.starting date and ending date with respective datetimepicker control.Now i have third label who computes the duration(difference)between dates.I have tried following code

C#

private void txtduration_MouseClick(object sender, MouseEventArgs e)
      {
          int n;
          if (startingdate.Value > endingdate.Value)
          {
              n = Convert.ToInt32(startingdate.Value - endingdate.Value);
              txtduration.Text = n.ToString();
          }
          else
              n = Convert.ToInt32(endingdate.Value - startingdate.Value);
          txtduration.Text = n.ToString();
}

getting an error
Unable to cast object to type 'System.Timespan' to type System.iconvertible

Please help me regarding this
Thanx in advance
regards

Posted 9-May-11 3:00am

shivani 2013

Updated 9-May-11 17:47pm

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Accepted Answer · 2011-05-09T03:19:00

If you subtract two DateTime data types, then you get a TimeSpan as a result. You are then trying to convert this into an int, which is not possible. Depending on what you are trying to do you need do do this:

C#

int n;
            if (startingdate.Value > endingdate.Value)
            {
                n = (int)(startingdate.Value - endingdate.Value).TotalSeconds;
                //n = (int)(startingdate.Value - endingdate.Value).TotalMinutes;
                //n = (int)(startingdate.Value - endingdate.Value).TotalDays; etc
                txtduration.Text = n.ToString();
            }
            else
                n = (int)(endingdate.Value - startingdate.Value).TotalSeconds;
            txtduration.Text = n.ToString();

This assumes you are trying to find the total duration in one of those formats

Hope this helps

How to operate arithmetic operation on dates?

1 solution

Solution 1

Add your solution here

Preview 0

How to operate arithmetic operation on dates?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us