(one should not mess up strg and shift :-/)
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is c
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is create it
> going 9, 8, 5, 10 on the dates. He
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
