Calculate with today in if clause

Posted in 2006

Summary

Dirk Emmermacher asked how to select rows with gebdat between (today - 6570) and (today - 10950) on a very old IDS 7.30 for an age-distribution report. Superboer showed an example using between today - 10000 units day and today - 5 units day. Art S. Kagel asked for version, platform and front-end details. No resolution appears in this thread (the reversed bounds were found in a related thread).

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

emmermacher@hotmail.com — 7 Nov 2006 06:10:56 -0800 — source: Usenet: comp.databases.informix

Hello list. 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

↪ replying to emmermacher@hotmail.com

Superboer — 7 Nov 2006 07:43:24 -0800 — source: Usenet: comp.databases.informix

dbaccessdemo7 <<! N ! dbaccess stores7 <<! select * from orders where order_date between today - 10000 units day and today - 5 unitsday ! see you Superboer. emmermacher@hotmail.com schreef: > Hello list. > > 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

↪ replying to emmermacher@hotmail.com

Art S. Kagel — Tue, 07 Nov 2006 13:51:28 -0500 — source: Usenet: comp.databases.informix

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 >

↪ replying to Art S. Kagel

TBP — Tue, 07 Nov 2006 19:08:00 GMT — source: Usenet: comp.databases.informix

Art S. Kagel wrote: > 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 >> Units? This could be in years, or seconds :p

↪ replying to Art S. Kagel

Carsten Haese — Tue, 07 Nov 2006 14:11:07 -0500 — source: Usenet: comp.databases.informix

On Tue, 2006-11-07 at 13:51 -0500, Art S. Kagel wrote: > Front-end (ie: Esql/C, Perl-DBD/DBI, ISQL (Perform, ACE), I4GL, R4GL, ODBC, > PHP, JDBC, Stored Procedures, etc.) You forgot Python ;) -Carsten