At 01:42 PM 10/11/2001 -0400, David Ebert wrote:
>Can I say logically that a given date falls in
>week (n) in any given year?
How about a COOL function, such as:
(IWK(arg,n))
IWK returns the week of the year.
Where arg is a value that has a DATE data type,
and n is the stating day of the week.
Example:
SET VAR vIwk = (IWK('10/11/2001',1))
Where Monday (1) is the starting day of week.
The resulting value of vIwk will be 41.
How about that?
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================