on 9/12/02 10:18 PM, Ken Schaefer at ken@a... wrote:

Would be nice if FrontBase had those vendor-specific date functions. As FB
is just full SQL92 compliant (and little more) I was able to work it out
with by comparing to an INTERVAL.

Thanx!

=Alan R.

> Something like a query where:
> 
> Month(Birthdate) < Month(Date())
> AND
> Year(BirthDate) < Year(Date())
> AND
> DateDiff("y"...)
>