Date range query

[Ivan Smahin]

Hello Ivan,




> The  original  query should select records which date is between now()
> and 7 days in advance. So you can do:

> select * from t1 where datediff(f1, now(), 'day') > 7

Sorry,
select * from t1 where datediff(f1, now(), 'day') between 0 and 7


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com