Format Date "WW" incorrect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
See Access VB Help on the different arguments you can use with the Format()
function.
 
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.


Van T. Dinh said:
See Access VB Help on the different arguments you can use with the Format()
function.

--
HTH
Van T. Dinh
MVP (Access)




Dave said:
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.
Click to expand...
Click to expand...
 
Back
Top