At 07:58 AM 30-05-01 -0700, you wrote:

>Hi all
>
>I was looking suggestion on how to select all the records in a table from
>today back 30 days
>is there some date variable I can use in IB6 to accomplish this?
>
>
>IBOQuery.sql:
>select * from tablename
>where datefield > (today - 30)
>how can I accomplish this ??

Almost exactly like your pseudocode:

...
where datefield > 'TODAY' - 30

or

where datefield > CURRENT_TIMESTAMP - 30
(if you want to get down to exact time of day).

Regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________