Calculate week number

[Swifey]

I have a daily date field formatted as yyyy-mm-dd. What I want to do is to create a new column which will calculate the week no.

For example:

2004-12-27 Week1
2004-12-28 Week1
2004-12-29 Week1
2004-12-30 Week1
2004-12-31 Week1

2005-01-03 Week3
2005-01-03 Week3

and so on....

Is this possible??

Many thanks

 

[tonnic]

Hi Swifey,

You can use the SQL-Statement below to update your column with the week-no.:

update

set [week-no] = format(date,'ww')

 

[Swifey]

Thank you for your help