Hi,

Building an ASPx timesheet for work - how can I figure out Saturday's date for the current week? Basically, I want to display a line on the page that reads "Week Ending: (_Saturday's Date_)" and then use that value throughout the rest of the timesheet.

I think that I did something like this a while back in classic ASP but I can't find my reference to it.

Thanks...

You can get the current day and then use a Select Case statement to add a number of days to it.  For example,

Select Case VariableofCurrentDay

Case Monday

'add five days

Case Tuesday

'add four days

End Select

Try the following:

      int numberOfDaysToSaturday = DayOfWeek.Saturday - DateTime.Now.DayOfWeek;

      DateTime saturday = DateTime.Now.AddDays(numberOfDaysToSaturday);

To stevenby -

Ok, that works but I noticed that it returns a 6 for Saturday, isn't it supposed to be a 7?

Thanks

Hi ewallig,

Give the following Method a try. Example:

/// <summary>
/// Gets the next occurence of future day.
/// </summary>
/// <param name="value">DateTime value to start with.</param>
/// <param name="dayOfWeek">Next Day of week to find.</param>
public DateTime GetNextOccurenceOfDay(DateTime value, DayOfWeek dayOfWeek)
{
      DateTime tempDate = value.AddDays(1);
      while(tempDate.DayOfWeek != dayOfWeek)
      {
      tempDate = tempDate.AddDays(1);
      }
      return tempDate;
}

Pass your date the next DayOfWeek you want to find and it will return you the date as a DateTime object. Can be used to find the next occurence of any DayOfWeek, not just Saturday.

Hope this helps.

ewallig wrote:

Ok, that works but I noticed that it returns a 6 for Saturday, isn't it supposed to be a 7?

Microsoft regard Sunday as the first day of the week and as we use 0 indexing this means that Saturday has a value of 6.

Hi BasicDatePicker

Thanks for the example - I'll give it a try

BasicDatePicker wrote:

public DateTime GetNextOccurenceOfDay(DateTime value, DayOfWeek dayOfWeek) {       DateTime tempDate = value.AddDays(1);       while(tempDate.DayOfWeek != dayOfWeek)       {       tempDate = tempDate.AddDays(1);       }       return tempDate; }

I like the idea but think that using a loop is inefficient. I suggest the following:

   int daysToAdd = dayOfWeek - value.DayOfWeek;

   if(daysToAdd < 1) {

      daysToAdd += 7;

   } 

   return value.AddDays(daysToAdd);

Hi stevenbey,

Nice work. Much better.

Here's the final code for all posterity in Visual Basic and C#.

[Visual Basic]

Public Function GetNextOccurenceOfDay(ByVal value As DateTime, ByVal dayOfWeek As DayOfWeek) As DateTime
      Dim daysToAdd As Integer = dayOfWeek - value.DayOfWeek
      If daysToAdd < 1 Then
            daysToAdd += 7
      End If
      Return value.AddDays(daysToAdd)
End Function

[C#]

/// <summary>
/// Gets the next occurence of future day.
/// </summary>
/// <param name="value">DateTime value to start with.</param>
/// <param name="dayOfWeek">Next Day of week to find.</param>
public DateTime GetNextOccurenceOfDay(DateTime value, DayOfWeek dayOfWeek)
   {
      int daysToAdd = dayOfWeek - value.DayOfWeek;
      if(daysToAdd < 1) 
      {
            daysToAdd += 7;
      } 
      return value.AddDays(daysToAdd);
}

Thanks for the code. I've included the function into my DateTimeHelper class and added extra methods like NextMonday and ClosestMonday(if passing parameter is Monday, the passing value will be return.