Get No Of Days

DECLARE @StartDate DATE = '2023-06-15';
DECLARE @EndDate DATE = '2023-06-19';

DECLARE @NumberOfDays INT;

SET @NumberOfDays = DATEDIFF(day, @StartDate, @EndDate);

SELECT @NumberOfDays;
 

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 

In sql you can do by using DATEDIFF()

SELECT DATEDIFF(day, '2023-06-10', '2023-06-15') AS NumberOfDays;

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);

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