curdate() getting strange results >> can someone help?

[sofasurfer]

hello!

ok, I need to output a result of a query when the date of the event is 15 days older than the current date or if the date of the event is "higher" that the current date.
my WHERE is something like this
SELECT bla bla bla
FROM bla bla bla
WHERE CURDATE() >= date - 15 AND provatipo_id = 4

date is a YYYY-MM-DD field in my MySQL database.

any help appreciated

thx! 🙂

[dhodge]

SELECT * FROM 'tablename' WHERE date < CURDATE() - 14 OR date > CURDATE()

sound right?