Display Week Number

[Former Member]

Does anyone know how to display the "Week" number in Crystal 2008? I need to break my report out by week 1, 2, 3....but I don't see a way so far. I have a date field but don't know how to convert that to the week number.

Thanks

[Former Member · Accepted solution]

Assuming you mean the Week number of the Year, you can create this formula to give you it:

//@WeekNumber

DatePart ("ww", {table.date})

[Former Member · Accepted solution]

Thanks! That is exactly what I needed.

[Former Member]

This is a helpful article depending on what you are trying to accomplish. |http://www.crystalkeen.com/articles/crystalreports/calculateweeknumber.htm]