Hi Sam,

just a WAG: could there be NULL dates in your data?

>Hi Borislav,
>
>I have changed the code as per your suggestion and I still get the same result as if nothing changes.
>
>> Change between(DOW(d1+D),2,6) to between(DOW(d1+D,1),2,6)
>
>Thanks,
>Sam