CODEWITHSUNDEEP
c#asp.net.netdatetime
sandeep
sandeep

Reputation: 2882

How to get all Dates given "Day Name" Between 2 Dates in c#

How to get All Days between given two Dates, given "Day Name"?
Ex: Start_Date = Jan 1, 2011
      End_Date = Jan 20, 2011
      Day Name = Sunday

Here we need to get all Dates with dayname as "SUNDAY"
Ex:

Jan 02, 2011
Jan 09, 2011
Jan 16, 2011

Upvotes: 0

Views: 2794

Answers (5)

Fredrik Mörk
Fredrik Mörk

Reputation: 158309

I like to use Enumerable.Range for tasks like that:

DateTime start = new DateTime(2011,1,1);
DateTime end = new DateTime(2011,1,20);

var datesThatAreSundays = Enumerable
    .Range(start.DayOfYear, end.Subtract(start).Days + 1)
    .Select(n => start.AddDays(n - start.DayOfYear))
    .Where(d => d.DayOfWeek == DayOfWeek.Sunday);

Upvotes: 12

napp
napp

Reputation: 3

You may try this

 var firstDate = new DateTime(2011, 1, 1);
 var lastDate = new DateTime(2011, 1, 20);

 var result = (from el in Enumerable.Range(0, (lastDate - firstDate).Days)
                      let date = firstDate.AddDays(el)
                      where date.DayOfWeek == DayOfWeek.Sunday
                      select date).ToArray();

Upvotes: 0

Wutz
Wutz

Reputation: 2942

Without having tested: 

DateTime start = x;
DateTime end = y;

while (start.DayOfWeek != z)
    start = start.AddDays(1);

while (start <= end)
{
    //DoStuff

    start = start.AddDays(7);
}

Upvotes: 0

Adriaan Stander
Adriaan Stander

Reputation: 166396

How about something like

DateTime startDate = new DateTime(2011, 01, 01);
DateTime endDate = new DateTime(2011, 01, 20);
string dayName = "sunday";

List<DateTime> list = new List<DateTime>();
for (DateTime runDate = startDate; runDate <= endDate; runDate = runDate.AddDays(1))
{
    if (runDate.DayOfWeek.ToString().ToLower() == dayName)
        list.Add(runDate);
}

or even using Enum.TryParse

DateTime startDate = new DateTime(2011, 01, 01);
DateTime endDate = new DateTime(2011, 01, 20);
string dayName = "sunday";
DayOfWeek dow;
Enum.TryParse(dayName, true, out dow);

List<DateTime> list = new List<DateTime>();
for (DateTime runDate = startDate; runDate <= endDate; runDate = runDate.AddDays(1))
{
    if (runDate.DayOfWeek == dow)
        list.Add(runDate);
}

Upvotes: 2

Alessandro
Alessandro

Reputation: 3761

DateTime startDate = new DateTime(2011, 1, 1);
DateTime endDate = new DateTime(2011, 1, 20);

while (startDate < endDate)
{
   if (startDate.DayOfWeek == DayOfWeek.Sunday)
   {
      // Do something
   }

   startDate = startDate.AddDays(1);
}

Upvotes: 2

Related Questions