Re: Calculate with today in if clause

Hello Art. I'm sorry :(. We're using isql (Perform, ACE). Best regards. Dirk Art S. Kagel schrieb: > emmermacher@hotmail.com wrote: > > Hello list. > > We need SOME details: > > Server version > Platform (OS & Hardware) > Front-end (ie: Esql/C, Perl-DBD/DBI, ISQL (Perform, ACE), I4GL, R4GL, ODBC, > PHP, JDBC, Stored Procedures, etc.) > > Art S. Kagel > > > I'got a small problem with one report. > > I have to write a report which results is an overview about age > > distribution in one table > > > > I try to use the if statement like > > if gebdat between (today - 6570) and (today - 10950) > > > > Gebdat is a date-type field. > > How can get result a want to have? > > IDS is an very old 7.30 > > > > Any ideas? > > > > Thanks in advance for your friendly advices. > > > > Best regards. > > > > Dirk Emmermacher > >