How do I loop through a date range

Question

I m not even sure how to do this without using some horrible for loop counter type solution   Here s the problem   I m given two dates  a start date and an end date and on a specified interval I need to take some action  For example  for every date between 3 10 2009 on every third day until 3 26 2009 I need to create an entry in a List  So my inputs would be   DateTime StartDate    3 10 2009   DateTime EndDate    3 26 2009   int DayInterval   3    and my output would be a list that has the following dates   3 13 2009 3 16 2009 3 19 2009 3 22 2009 3 25 2009  So how the heck would I do something like this  I thought about using a for loop that would iterate between every day in the range with a separate counter like so   int count   0   for int i   0  i  lt  n  i           count         if count  gt   DayInterval                     take action           count   0              But it seems like there could be a better way

User · Answer

According to the problem you can try this...

// looping between date range    
while (startDate <= endDate)
{
    //here will be your code block...

    startDate = startDate.AddDays(1);
}

thanks......

User · Answer

Iterate every 15 minutes  DateTime startDate   DateTime Parse  2018-06-24 06 00            DateTime endDate   DateTime Parse  2018-06-24 11 45             while  startDate AddMinutes 15   lt   endDate                         Console WriteLine startDate ToString  yyyy-MM-dd HH mm                 startDate   startDate AddMinutes 15

User · Answer

1 Year later  may it help someone   This version includes a predicate  to be more flexible   Usage  var today   DateTime UtcNow  var birthday   new DateTime 2018  01  01     Daily to my birthday  var toBirthday   today RangeTo birthday       Monthly to my birthday  Step 2 months  var toBirthday   today RangeTo birthday  x   gt  x AddMonths 2      Yearly to my birthday  var toBirthday   today RangeTo birthday  x   gt  x AddYears 1      Use RangeFrom instead     same result var fromToday   birthday RangeFrom today   var toBirthday   today RangeTo birthday     Implementation  public static class DateTimeExtensions         public static IEnumerable lt DateTime gt  RangeTo this DateTime from  DateTime to  Func lt DateTime  DateTime gt  step   null                if  step    null                        step   x   gt  x AddDays 1                      while  from  lt  to                        yield return from              from   step from                        public static IEnumerable lt DateTime gt  RangeFrom this DateTime to  DateTime from  Func lt DateTime  DateTime gt  step   null                return from RangeTo to  step             Extras  You could throw an Exception if the fromDate  gt  toDate  but I prefer to return an empty range instead

User · Answer

You might consider writing an iterator instead  which allows you to use normal  for  loop syntax like       I searched and found a similar question answered here on StackOverflow which gives pointers on making DateTime iterable

User · Answer

You can use the  DateTime AddDays   function to add your DayInterval to the StartDate and check to make sure it is less than the EndDate

User · Answer

DateTime startDate   new DateTime 2009  3  10   DateTime stopDate   new DateTime 2009  3  26   int interval   3   while   startDate   startDate AddDays interval    lt   stopDate           do your thing

User · Answer

DateTime startDate   new DateTime 2009  3  10   DateTime stopDate   new DateTime 2009  3  26   int interval   3   for  DateTime dateTime startDate       dateTime  lt  stopDate        dateTime    TimeSpan FromDays interval

User · Answer

For your example you can try  DateTime StartDate   new DateTime 2009  3  10   DateTime EndDate   new DateTime 2009  3  26   int DayInterval   3   List lt DateTime gt  dateList   new List lt DateTime gt     while  StartDate AddDays DayInterval   lt   EndDate       StartDate   StartDate AddDays DayInterval      dateList Add StartDate

User · Answer

I have a Range class in MiscUtil which you could find useful  Combined with the various extension methods  you could do   foreach  DateTime date in StartDate To EndDate  ExcludeEnd                                       Step DayInterval Days             Do something with the date      You may or may not want to exclude the end - I just thought I d provide it as an example    This is basically a ready-rolled  and more general-purpose  form of mquander s solution

User · Answer

DateTime begindate   Convert ToDateTime  01 Jan 2018    DateTime enddate   Convert ToDateTime  12 Feb 2018     while  begindate  lt  enddate         begindate  begindate AddDays 1       Console WriteLine begindate          enddate

User · Answer

you have to be careful here not to miss the dates when in the loop a better solution would be   this gives you the first date of startdate and use it in the loop before incrementing it and it will process all the dates including the last date of enddate hence  lt   enddate   so the above answer is the correct one   while  startdate  lt   enddate           do something with the startdate     startdate   startdate adddays interval

User · Answer

jacob-sobus and  mquander and  Yogurt not exactly correct   If I need the next day I wait 00 00 time mostly      public static IEnumerable lt DateTime gt  EachDay DateTime from  DateTime thru                for  var day   from Date  day Date  lt   thru Date  day   day NextDay                yield return day             public static IEnumerable lt DateTime gt  EachMonth DateTime from  DateTime thru                for  var month   from Date  month Date  lt   thru Date    month Year    thru Year  amp  amp  month Month    thru Month  month   month NextMonth                yield return month             public static IEnumerable lt DateTime gt  EachYear DateTime from  DateTime thru                for  var year   from Date  year Date  lt   thru Date    year Year    thru Year  year   year NextYear                yield return year             public static DateTime NextDay this DateTime date                return date AddTicks TimeSpan TicksPerDay - date TimeOfDay Ticks              public static DateTime NextMonth this DateTime date                return date AddTicks TimeSpan TicksPerDay   DateTime DaysInMonth date Year  date Month  -  date TimeOfDay Ticks   TimeSpan TicksPerDay    date Day - 1                public static DateTime NextYear this DateTime date                var yearTicks    new DateTime date Year   1  1  1  - new DateTime date Year  1  1   Ticks          var ticks    date - new DateTime date Year  1  1   Ticks          return date AddTicks yearTicks - ticks              public static IEnumerable lt DateTime gt  EachDayTo this DateTime dateFrom  DateTime dateTo                return EachDay dateFrom  dateTo              public static IEnumerable lt DateTime gt  EachMonthTo this DateTime dateFrom  DateTime dateTo                return EachMonth dateFrom  dateTo              public static IEnumerable lt DateTime gt  EachYearTo this DateTime dateFrom  DateTime dateTo                return EachYear dateFrom  dateTo

User · Answer

Well  you ll need to loop over them one way or the other   I prefer defining a method like this   public IEnumerable lt DateTime gt  EachDay DateTime from  DateTime thru        for var day   from Date  day Date  lt   thru Date  day   day AddDays 1           yield return day      Then you can use it like this   foreach  DateTime day in EachDay StartDate  EndDate          print it or whatever   In this manner you could hit every other day  every third day  only weekdays  etc   For example  to return every third day starting with the  start  date  you could just call AddDays 3  in the loop instead of AddDays 1

User · Answer

Here are my 2 cents in 2020   Enumerable Range 0   endDate - startDate  Days   1   ToList    Select a   gt  startDate AddDays a

User · Answer

Code from  mquander and  Yogurt The Wise used in extensions   public static IEnumerable lt DateTime gt  EachDay DateTime from  DateTime thru        for  var day   from Date  day Date  lt   thru Date  day   day AddDays 1           yield return day     public static IEnumerable lt DateTime gt  EachMonth DateTime from  DateTime thru        for  var month   from Date  month Date  lt   thru Date    month Month    thru Month  month   month AddMonths 1           yield return month     public static IEnumerable lt DateTime gt  EachDayTo this DateTime dateFrom  DateTime dateTo        return EachDay dateFrom  dateTo      public static IEnumerable lt DateTime gt  EachMonthTo this DateTime dateFrom  DateTime dateTo        return EachMonth dateFrom  dateTo

User · Answer

you can use this    DateTime dt0   new DateTime 2009  3  10    DateTime dt1   new DateTime 2009  3  26     for    dt0 Date  lt   dt1 Date  dt0 dt0 AddDays 3            Console WriteLine dt0 Date ToString  yyyy-MM-dd           take action

[c#] How do I loop through a date range?

Examples related to c#

Examples related to asp.net

Examples related to datetime

Examples related to loops