SQL help ?

OK, well you wouldn't need to do the date bit in CF.  The DB is just as aware of what a date is as CF is, so there's no need/point in doing the date bit in CF then passing it to the DB, when the DB can do the whole lot by itself.  I pointed you to the correct page... that's got MySQL's date functions on it (well: in a link on the RHS), including MySQL's equivalent to CF's now() function, which - oddly enough - is called... now() (I'm not meaning sounding smug or sarcastic here... I did not know until I checked just now).

So you - perhaps inadvertantly - didn't need help with the now() bit as you already had it right.  It's just the operator bit you needed help with.

My point stands, though: asking Qs on the correct forum is a good approach (even though you got the right answer - maybe - here), because you're more likely to get better answers.  I'm working with a DBA for the first time in my professional career at present and it's driven home to me how little - as a CF developer - I really know about DBs (and I don't think I'm particularly thick when it comes to DBs/SQL).  CF bods will know enough to get by, but people focusing on the DB will know the best way to do things. Also, CF people will be splitting their DB competence across a number of platforms (SQL Server, Oracle, MySQL, etc), whereas people on a MySQL forum will be experts in MySQL.  I wasn't trying to be dismissive.  Although it probably sounded that way (eating dinner with one hand, one the phone with another, typing with my... um... magic third hand, I guess ;-)

--

Adam