SELECT * FROM table WHERE (Status != closed) OR ((Status = closed) AND
(Date Now - # of seconds in 2 weeks))
That should work if your Date field is just a regular timestamp. It all
depends on how you're storing the date...
- Jonathan
-Original Message-
From: Chris Boget [mailto:[EMAIL
Should be something like
Select Status, Date from Table where Status closed or Date now()
- 14
(This is from memory so please dont rely on the syntax ;-)
HTH,
Chris
--
Christian Pfeiffer
Smart-Link Gesellschaft für EDV-Systemlösungen mbH
Herforder Str. 5-7 www.smart-link.de