query on date VIP

[msleem]

I want to do a query by Select Statement on date BUT the problem that I want to make this query at 5 days before the date in the table. For Ex, I have date 6-1-2006 {with format(dd-MM-yyyy)} THEN, I want when the query works give me a message before 5 days from this date, THAT MEANS the query will give me the message at 1-1-2006. I realy wanna do that, and maney thanks for help...........

soly

[Rocky]

well I dontknow exactly what ur trying to do but think abt using this now()// the function for todays date if now()+5 = print (or whatever) "hi there"

[Colin Angus Mackay]

If you tell us what this is being used for then it might help with the answer. I can think of 2 or 3 ways, but they all have limitations which are acceptable in different scenarios.

---

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog