Subtrating two dates to calculate number of days

Question

how to subtract two datetime without subtracting time?

Iftikar Hussain · Answer

what exactly you are looking for? Explain us with example Regards Iftikar

Sanjeeb Lenka · Answer

hi  your code is giving the correct answer. no or days between current day and input day. so what the problem you are getting.

Nahul Antony · Answer

TimeSpan ts = new TimeSpan(); double s1; double s2; DateTime dt = System.DateTime.Today; DateTime dt1 = dtpDate.Value; ts = (dt - dt1); s1 = Convert.ToDouble(ts.TotalDays); //s2 = Convert.ToDouble(ts.TotalMinutes); txtTotDays.Text = Convert.ToString(s1); i not need to subtract time.i need date to subtract from datetime

Sanjeeb Lenka · Answer

try this: date in mm/dd/yyyy format DateTime d1=Convert.ToDateTime(12/22/2013); DateTime d2 = Convert.ToDateTime(12/22/2012); var d = (d1 - d2).TotalDays; output:365

Nahul Antony · Answer

in C# i not need to subtract time from datetime.take date only to calculate number of days

Nahul Antony · Answer

how to take date from datetime to subtract when i using that code subtracting number of days not coming correct manner

Iftikar Hussain · Answer

Hi Can you provide your example? Regards Iftikar

Nahul Antony · Answer

i not need to subtract time format how to take date from datetime format to subtract and know to calculate number of days

Jignesh Trivedi · Answer

hi Are you looking in SQL or C#? if it is in C# than agree with above answer if you look in SQL than try select DATEDIFF(d'2013-05-20 12:12:45''2013-07-20 15:12:45') hope this will help you.

Vulpes · Answer

If you want to ignore the time components altogether in the calculation I'd use: TimeSpan difference = dateTime1.Date - dateTime2.Date; int days = (int)difference.TotalDays;

Sanjeeb Lenka · Answer

try this : TimeSpan difference = dateTime1 - dateTime2 ; difference.TotalDays will give you number of days var days = difference . TotalDays ;