date to sum

Maneesh A N

how to sum date in sql 2005..i jest selected from date and to date from date time picker

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Srivastava13y ago
Try this:

        DateTime dtFrom;
        DateTime dtTo;
        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            dtFrom = dateTimePicker_From.Value;
        }
        private void dateTimePicker_To_ValueChanged(object sender, EventArgs e)
        {
            dtTo = dateTimePicker_To.Value;
        }
        private void btn_CalcDays_Click(object sender, EventArgs e)
        {
            TimeSpan timespan = new TimeSpan();
            timespan = dtTo - dtFrom ;
            MessageBox.Show(Math.Abs(timespan.Days).ToString());
        }
SUNIL GUTTA13y ago
U mean what mate .. difference of days b/w the mentioned dates ? So use DateTime which is overloaded . .. ..
Sunny Sharma13y ago
Hi Maneesh,

Please explain how you want the Date to be summed up? Any Sample demo would be great.