>Sorry for the thick-headedness.

You mean you're human?? ;>} (Guy quoted below claims he's Borg!)

>In Oracle, there is a function called MONTHS_BETWEEN
>
>There is another function called ADD_MONTHS

Rdb takes only ANSI SQL-92 functions and commands. I got the following from the MSFT NG:

"According to Joe Celko there is a section for handling date/time data types
in the SQL-92 specification. However, because of the complexities no vendor
has implemented these specs yet. This information was copyrighted in 1995
and is contained in the book, SQL for Smarties: Advanced SQL Programming.
Chapter 4 deals with date/time issues and how to implement some simple date
arithmetic."

What I will be doing is getting more data than I need and doing some Fox date-handling locally. Here's to work-arounds!!

Also, I have the 2nd Edition of Celko's book (published 7/99 ! ) on order.

Thanks for your attention.