Format date as weeknumber

[GoTerps88]

Does such a function exist?

I was thinking "{0:ww}" or something but that doesn't work.

Thanks...

 

[litton1]

As far as I am aware there is nothing like that? I think you have to do it the old fashion way

/// <summary>
/// find week number
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private static int FindWeekNumber( DateTime searchDate )
{		
    const double weekDay = 7.0;
    int weekNum = 1;

    DateTime newWeek = new DateTime( DateTime.Now.Year, 1, 1 );
    for ( int i = 0; i < 365; i++ )
    {
	newWeek = newWeek.AddDays( weekDay );
	if ( newWeek > searchDate )
	   break;
	else
           weekNum++;
    }
    return weekNum;
 }

this code needs to go backwards to the begining of the week after the loop just to check if the week is this week?

Age is a consequence of experience

 

[litton1]

whoops, 6 needs to be added to i in the loop

Age is a consequence of experience

 

[misterstick]

there are 1,710,000 hits for week number c# in google so there must be an easier way than iterating through every day of the year. ISO 8601 looks pretty damn complicated, too.


mr s. <

 

[litton1]

this one seems a good method?

http://codebetter.com/blogs/peter.van.ooijen/archive/2005/09/26/132466.aspx

Age is a consequence of experience

 

[JurkMonkey]

Doesn't DateTime have a dayofyear method? You could use that as a starting point.

http://www.ubuntu.com/

 

[GoTerps88]

The work around I created was using a calculated field from the database that formatted the weeknumber, then create a bound column in the gridview based on that.

I'm assuming that if I created my own weeknumber function, I would have to implement that in the RowDataBound event.