How to get dates between two dates in C#

How to get dates between two dates in C#

In C#, you can use a loop to get all dates between two given dates. Here's an example:

DateTime startDate = new DateTime(2022, 1, 1); DateTime endDate = new DateTime(2022, 1, 31); List<DateTime> dates = new List<DateTime>(); for (DateTime date = startDate; date <= endDate; date = date.AddDays(1)) { dates.Add(date); }

In this example, we create a startDate and an endDate and initialize a List<DateTime> called dates.

We then use a for loop to iterate through all dates between the startDate and the endDate, adding each date to the dates list.

The AddDays method is used to increment the date by one day on each iteration of the loop.

At the end of the loop, the dates list will contain all dates between the startDate and the endDate, inclusive.

Examples

  1. "C# get all dates between two dates"

    • Description: Learn how to generate a list of all dates between two given dates in C#.
    DateTime startDate = new DateTime(2023, 3, 1); // Example start date DateTime endDate = new DateTime(2023, 3, 10); // Example end date List<DateTime> allDates = Enumerable.Range(0, (endDate - startDate).Days + 1) .Select(offset => startDate.AddDays(offset)) .ToList();

  2. "C# get weekdays between two dates"

    • Description: Explore how to obtain only weekdays (Monday to Friday) between two dates in C#.
    DateTime startDate = new DateTime(2023, 3, 1); // Example start date DateTime endDate = new DateTime(2023, 3, 10); // Example end date List<DateTime> weekdays = Enumerable.Range(0, (endDate - startDate).Days + 1) .Select(offset => startDate.AddDays(offset)) .Where(date => date.DayOfWeek != DayOfWeek.Saturday && date.DayOfWeek != DayOfWeek.Sunday) .ToList();

  3. "C# get all months between two dates"

    • Description: Understand how to retrieve a list of all months between two given dates in C#.
    DateTime startDate = new DateTime(2023, 1, 1); // Example start date DateTime endDate = new DateTime(2023, 12, 31); // Example end date List<DateTime> allMonths = Enumerable.Range(0, (endDate.Year - startDate.Year) * 12 + endDate.Month - startDate.Month + 1) .Select(offset => new DateTime(startDate.Year, startDate.Month, 1).AddMonths(offset)) .ToList();

  4. "C# get specific day of the week between two dates"

    • Description: Learn how to obtain all instances of a specific day of the week between two dates in C#.
    DateTime startDate = new DateTime(2023, 3, 1); // Example start date DateTime endDate = new DateTime(2023, 3, 10); // Example end date DayOfWeek targetDay = DayOfWeek.Wednesday; // Example target day List<DateTime> specificDays = Enumerable.Range(0, (endDate - startDate).Days + 1) .Select(offset => startDate.AddDays(offset)) .Where(date => date.DayOfWeek == targetDay) .ToList();

  5. "C# get hours between two DateTime values"

    • Description: Explore how to obtain a list of all hours between two DateTime values in C#.
    DateTime startTime = new DateTime(2023, 3, 1, 8, 0, 0); // Example start time DateTime endTime = new DateTime(2023, 3, 1, 17, 0, 0); // Example end time List<DateTime> allHours = Enumerable.Range(0, (int)(endTime - startTime).TotalHours + 1) .Select(offset => startTime.AddHours(offset)) .ToList();

  6. "C# get quarters between two dates"

    • Description: Learn how to retrieve a list of all quarters (3-month intervals) between two given dates in C#.
    DateTime startDate = new DateTime(2023, 1, 1); // Example start date DateTime endDate = new DateTime(2023, 12, 31); // Example end date List<DateTime> allQuarters = Enumerable.Range(0, (endDate.Year - startDate.Year) * 4 + (endDate.Month - 1) / 3 - (startDate.Month - 1) / 3 + 1) .Select(offset => new DateTime(startDate.Year, ((startDate.Month - 1) / 3 + offset) * 3 + 1, 1)) .ToList();

  7. "C# get weeks between two dates"

    • Description: Understand how to obtain a list of all weeks between two given dates in C#.
    DateTime startDate = new DateTime(2023, 3, 1); // Example start date DateTime endDate = new DateTime(2023, 3, 10); // Example end date List<DateTime> allWeeks = Enumerable.Range(0, (endDate - startDate).Days / 7 + 1) .Select(offset => startDate.AddDays(offset * 7)) .ToList();

  8. "C# get minutes between two DateTime values"

    • Description: Explore how to obtain a list of all minutes between two DateTime values in C#.
    DateTime startTime = new DateTime(2023, 3, 1, 8, 0, 0); // Example start time DateTime endTime = new DateTime(2023, 3, 1, 8, 30, 0); // Example end time List<DateTime> allMinutes = Enumerable.Range(0, (int)(endTime - startTime).TotalMinutes + 1) .Select(offset => startTime.AddMinutes(offset)) .ToList();

  9. "C# get seconds between two DateTime values"

    • Description: Learn how to obtain a list of all seconds between two DateTime values in C#.
    DateTime startTime = new DateTime(2023, 3, 1, 8, 0, 0); // Example start time DateTime endTime = new DateTime(2023, 3, 1, 8, 0, 30); // Example end time List<DateTime> allSeconds = Enumerable.Range(0, (int)(endTime - startTime).TotalSeconds + 1) .Select(offset => startTime.AddSeconds(offset)) .ToList();

  10. "C# get months and years between two dates"

    • Description: Understand how to obtain a list of all months and years between two given dates in C#.
    DateTime startDate = new DateTime(2023, 1, 1); // Example start date DateTime endDate = new DateTime(2023, 12, 31); // Example end date List<DateTime> allMonthsAndYears = Enumerable.Range(0, (endDate.Year - startDate.Year) * 12 + endDate.Month - startDate.Month + 1) .Select(offset => new DateTime(startDate.Year, startDate.Month, 1).AddMonths(offset)) .ToList();

More Tags

typescript2.0 maximo kafka-producer-api catalan jquery-ui-draggable mysql-error-1071 android-typeface npm-link gauge indexoutofboundsexception

More C# Questions

More Financial Calculators

More Entertainment Anecdotes Calculators

More Animal pregnancy Calculators

More Math Calculators