Synatax Query - Less than or Equal to

Any Ideas?

That's pretty much what the core of mine is:

SELECT CONTNOTES.ACTDATE, CONTACTS.CONTACTID, CONTACTS.LOGO, CONTACTS.COMPANY, CONTACTS.FULLNAME, CONTNOTES.NOTEUSER, CONTNOTES.STAGE, CONTNOTES.TYPE, CONTNOTES.NOTE, CONTNOTES.VALUE, CONTNOTES.COMPLETED
FROM CONTACTS INNER JOIN CONTNOTES ON CONTACTS.CONTACTID = CONTNOTES.NOTESCONTACTID
WHERE CONTNOTES.NOTEUSER='coluser' AND (CONTNOTES.ACTDATE<='coldatetil' OR CONTNOTES.ACTDATE is null) AND CONTNOTES.TYPE <>'10 note' AND CONTNOTES.COMPLETED=False
ORDER BY CONTNOTES.ACTDATE DESC

And yet it still only seems to return the less than part of <=

RichardODreamweaver wrote:
> I want to create a recordset where activities are less than or equal to
> today's date.

SELECT * FROM myTable
WHERE theDate <= CURDATE()

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/