I use function week but it always return incorrect week.

example

select week ('2007-01-01','2007-01-03') returns week 0 instead of week 1
select week ('2007-01-01','2007-01-08') returns week 1 instead of week 2

is there a bug in ASA.
I try in ASA version 6,9 and 10 with the same result
always returns a week -1.

In my understanding the function weeks works fine. It returns the number
of weeks (of 7 days) between the two dates.
This is in difference to datediff( week,.... ) which returns the number
of Sundays between the two dates including the second date but not the
first.

Regards
Arthur

Raymundo Betancourt wrote:

The WEEKS function returns the number of Sundays between two dates. The
results you get from ASA are correct. If you want different results, you may
need to write your own function.

Richard


"Raymundo Betancourt" <rbetancourt (AT) csnetbc (DOT) com> wrote