Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Week error in 5.0

Status
Not open for further replies.

Gerb

Technical User
Jan 8, 2002
6
GB
When using the function Week() I noticed that for example 2 jan 2002 is converted to week 53 in stead of week 1. No doubt because of the 31st of december is on monday but still...
The obvious work around: if year(<>)=2002 then week(<>)+1 else week(<>) works ok, but isn't there something better?
 
In BO the first full week in January is week 1.
This is default behaviour.
You can't change the settings to force BO to give the right week number, so you'll have to use a workaround.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top