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 ??

Thanks
Daniel