Getting Started

Re: Week Ending...

MNF — Thu, 24 Jan 2008 11:20:03 GMT

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.

Re: Week Ending...

BasicDatePicker — Tue, 12 Apr 2005 19:49:44 GMT

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);
}

Re: Week Ending...

stevenbey — Tue, 12 Apr 2005 12:34:25 GMT

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);

Re: Week Ending...

ewallig — Mon, 11 Apr 2005 12:09:03 GMT

Hi BasicDatePicker

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

Re: Week Ending...

stevenbey — Mon, 11 Apr 2005 08:49:20 GMT

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.

Re: Week Ending...

BasicDatePicker — Wed, 06 Apr 2005 20:17:43 GMT

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.

Re: Week Ending...

ewallig — Wed, 06 Apr 2005 18:28:17 GMT

To stevenby -

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

Thanks

Re: Week Ending...

stevenbey — Wed, 06 Apr 2005 16:19:21 GMT

Try the following:

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

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

Re: Week Ending...

jamesqua — Wed, 06 Apr 2005 16:12:10 GMT

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

Week Ending...

ewallig — Wed, 06 Apr 2005 14:56:13 GMT

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...