i have a table with a fieldname "plansewing" from datatype "date"
i want to select all orders, where the plansewing-date is not "older" than 30 days,
something like:

select * from orders where plansewing < date+30  (or < now+30) ---but it dont work...
dbisam dont know the actual date from the server?

Thomas <info@magoarte.com> wrote:

i have a table with a fieldname "plansewing" from datatype "date"
i want to select all orders, where the plansewing-date is not "older" than 30 days,
something like:

select * from orders where plansewing < date+30  (or < now+30) ---but it dont work...
dbisam dont know the actual date from the server?

i tried it now with

select * from orders where plansewing < current_date+30 ---
the querey is running, but dont bring the correct results, also show me orders with
plansewing-date from May 07

Thomas <info@magoarte.com> wrote:

Thomas <info@magoarte.com> wrote:

i have a table with a fieldname "plansewing" from datatype "date"
i want to select all orders, where the plansewing-date is not "older" than 30 days,
something like:

select * from orders where plansewing < date+30  (or < now+30) ---but it dont work...
dbisam dont know the actual date from the server?

i tried it now with

select * from orders where plansewing < current_date+30 ---
the querey is running, but dont bring the correct results, also show me orders with
plansewing-date from May 07

sorry, sorry, was my fault, i had inserted the > sign instead <
great, its working, sorry once more, this threat can be deleted.