Previous Discussion	Next Discussion

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

4 Response(s) | Reply

View All Replies

Monte on Oct 23, 2009 at 2:30:54 PM What DB are you using? Is there a TODAY()? Or maybe it's a formatting issue with the date. How is events.eventDate formatted compared to NOW()?

View All Replies

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.