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?
The obvious work around: if year(<>)=2002 then week(<>)+1 else week(<>) works ok, but isn't there something better?