Hello, i´m using Openoffice since 2 weeks ist a realy good programm! but now i´ve got a problem. I have created a database with OOo Base and i want using SQL to delete old data form the db
DELETE FROM "Aufträge" WHERE "Liefertermin" < SYSDATE this command line works but i want to delete data where 14 days older than the SYSDATE / NOW SYSDATE - 14 DAYS or SYSDATE - 14 DAY or SYSDATE - 14 dosen´t work can you help me? You can answer the mail in english or german too. greetings Kristian -------------------------------------------------------------------------- Get a spam free email account - Visit http://www.bluebottle.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
