Week Numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chav.. - 04 Jan 2005 15:15 GMT

Hi can any one help we use the week() function a lot within our software,
this year seems to have thrown up a problem now on Jan the 4th the function
returns week number 2. Ok so I have set FWeek to the correct value and FDOW
however this has no effect on the week number. If you use the week(date(),2)
then the correct week number is returned. It would seem like a bug this is
happening on all versions up to v8.

Thanks
Terry

Reply to this Message

Fernando D. Bozzo - 04 Jan 2005 16:41 GMT

Hi Terry:

Reading the WEEK() function help, it seems that you must provide the
optional arguments to make it work.
It says that you must give '0' to last 2 arguments for using the SET FDOW
and SET FWEEK values, or you can select another values to overwrite those
SET's.

Example:
week(date(), 0, 0) && To use the FDOW and FWEEK settings

This way WEEK() returns 2 using SET FWEEK TO 1, and returns 1 using SET
FWEEK TO 2 or 3

Regards,

Fernando D. Bozzo

> Hi can any one help we use the week() function a lot within our software,
> this year seems to have thrown up a problem now on Jan the 4th the function
[quoted text clipped - 5 lines]
> Thanks
> Terry

Reply to this Message