 NOW() +1
Probably a really simple one but I'm stuck I can select records from a recordset based upon dates up until today -
SELECT *
FROM events
WHERE events.eventDate>=NOW()
ORDER BY events.eventDate
But that misses out any records for TODAY!!
I tried variations on NOW()+1 but am stuck and can find no online reference to it whichreally surprised me as I assume this must be a common requirement!?
Any pointers? Started By Jockrock on Oct 23, 2009 at 8:22:51 AM | 
