Format Date "WW" incorrect

[Dave]

I have a field which converts dates to the respective calender week by using
Format ([date_field],ww).

This worked Ok for 2004, however in 2005 it is 1 week in front of itself as
it is counting the first week of January as calender week 2 instead of
calender week 1.

I know there is a way to set the format to count the first calender week as
the week having 4 days in it (as can be set up in outlook calender).

Please can anyone let me know the formula for this.

 

[Van T. Dinh]

See Access VB Help on the different arguments you can use with the Format()
function.

 

[Dave]

Hi and many thanks

I have just found it and have tried it with great success.

I have used: Format ([datefield],"ww",0,2) and it works fine.

Once again many thanks
Dave.

See Access VB Help on the different arguments you can use with the Format()
function.

--
HTH
Van T. Dinh
MVP (Access)

I have a field which converts dates to the respective calender week by using
Format ([date_field],ww).

This worked Ok for 2004, however in 2005 it is 1 week in front of itself as
it is counting the first week of January as calender week 2 instead of
calender week 1.

I know there is a way to set the format to count the first calender week as
the week having 4 days in it (as can be set up in outlook calender).

Please can anyone let me know the formula for this.