Get No Of Days

Question

Hi How to subtract 2 dates & get No Of Days Thanks

Vishal Yelve · Answer

Hi Ramco, Try this using System; public class Program { public static void Main() { var prevDate = new DateTime(2021, 11, 23); //23 Nov 2021 var today = DateTime.Now; //get difference of two dates var diffOfDates = today - prevDate; Console.WriteLine("Difference in Days: {0}", diffOfDates.Days); } } OutPut

Amit Mohanty · Answer

DateTime startDate = new DateTime(2023, 6, 10); DateTime endDate = new DateTime(2023, 6, 15); TimeSpan duration = endDate.Subtract(startDate); int numberOfDays = duration.Days; Console.WriteLine("Number of days: " + numberOfDays);

Brahma Prakash Shukla · Answer

DECLARE @StartDate DATE = '2023-06-15'; DECLARE @EndDate DATE = '2023-06-19'; DECLARE @NumberOfDays INT; SET @NumberOfDays = DATEDIFF(day, @StartDate, @EndDate); SELECT @NumberOfDays;

Raj Bhatt · Answer

In sql you can do by using DATEDIFF() SELECT DATEDIFF(day, '2023-06-10', '2023-06-15') AS NumberOfDays;

cjard · Answer

Like you would numbers laterDate - earlierDate The operation results in a TimeSpan object that describes the period of time between the two dates For example: var ts = laterDate - earlierDate; var daysBetween = ts.TotalDays; daysBetween will be a double, as the period between the dates could have fractions of a day; the time period between noon on 2nd Jan and midnight in 1st Jan is 1.5 days. If you only want whole days, you can cast to an int, use Math.Floor etc. Take a look at the other properties of a TimeSpan in the documentation for further ideas on how to work with it Note, like numbers, if you do earlierDate - laterDate, you'll get a negative TimeSpan

Get No Of Days

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)