Thanks Helen,
Daniel


At 01:18 AM 31/05/2001 +1000, you wrote:

>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
>_______________________________________________________
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/