finding date between terms of dates

Question

I have an array of terms which have start-dates and end-dates. how can I find whether today falls between the terms. code is

  var termsforcurrentCalendar = UnitOfWork.SchoolTerms.Query().Where(x
  => x.SchoolCalendarId == currentCalendar.SchoolCalendarId).ToArray();

   var noOfTerms = termsforcurrentCalendar.Count();

    for (int i = 0; i < noOfTerms; i++)
   {
      if (DateTime.Today > termsforcurrentCalendar[i].EndDate)
      {
          if (i != noOfTerms)
       {
           if (DateTime.Today < termsforcurrentCalendar[i + 1].StartDate)
        {
           datetoBeChecked = termsforcurrentCalendar[i + 1].StartDate;
        }
     }
    }
   }

possible duplicate of [How to know if a DateTime is between a DateRange in C#](http://stackoverflow.com/questions/4781611/how-to-know-if-a-datetime-is-between-a-daterange-in-c-sharp) — Ian, Oct 24 '13 at 09:35
I have edited your title. Please see, "[Should questions include “tags” in their titles?](http://meta.stackexchange.com/questions/19190/)", where the consensus is "no, they should not". — John Saunders, Oct 24 '13 at 10:09

dav_i · Answer 1 · 2013-10-24T10:11:48.440

1

How about using a bit of linq niceness:

var isTodayInTerm = termsforcurrentCalendar.Any(a => 
    DateTime.Today >= a.StartDate && DateTime.Today <= a.EndDate);

As per comment, to get the next term:

var nextTerm = termsforcurrentCalendar.OrderBy(a => a.StartDate).FirstOrDefault(a =>
    a.StartDate >= DateTime.Today);

edited Oct 24 '13 at 10:11

answered Oct 24 '13 at 09:35

dav_i

27,509
17
104
136

if today falls between terms get the next terms first date – user1032957 Oct 24 '13 at 09:42
1

Please edit your question then, as the answer provided answers your question perfectly. – decPL Oct 24 '13 at 09:45
What if there are two terms with startdates more than the 'today' ? – tariq Oct 24 '13 at 10:08
@tariq Then it gets the first one. – dav_i Oct 24 '13 at 10:09
@tariq If he has two starting on the same day then you cannot be certain of which will be selected - but the OP did not provide enough information to deal with this case. – dav_i Oct 24 '13 at 10:12
i think that you should order the list first and then pick up the first one – tariq Oct 24 '13 at 10:16

score 0 · Accepted Answer · answered Oct 24 '13 at 09:56

  var isTodayInTerm = termsforcurrentCalendar.Any(a =>DateTime.Today >= a.StartDate && DateTime.Today <= a.EndDate);

    if (!isTodayInTerm)
    {
        var firstAvailableDate = termsforcurrentCalendar.FirstOrDefault(z => z.StartDate > DateTime.Today);
        datetoBeChecked = firstAvailableDate.StartDate;
    }

score 0 · Answer 3 · answered Oct 24 '13 at 10:07

var isTodayInTerm = termsforcurrentCalendar.Any(a =>DateTime.Today >= a.StartDate && DateTime.Today <= a.EndDate);

if (!isTodayInTerm)
{
    var firstAvailableDate = termsforcurrentCalendar.OrderBy(a=>a.StartDate).FirstOrDefault(z => z.StartDate > DateTime.Today);
    datetoBeChecked = firstAvailableDate.StartDate;
}

finding date between terms of dates

3 Answers3