Do you want "today" as in calendar day or "today" as in a 24 hour window? There's a big difference.
What database server? What datatype is tblBooking.DateBooking? - Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Baird Sent: Sunday, April 03, 2005 5:16 PM To: [email protected] Subject: not giving me today on a SELECT THis select statement is not giving me records for today, and yes I already checked my clock for the date, etc. How would I make it select entries starting from a day earlier than the day I execute the select statement? SELECT tblBooking.DateBooking, tblReservation.EventName, tblGroup.GroupName, (tblBooking.DateBooking + tblBooking.TimeBookingStart) AS booking_start, (tblBooking.DateBooking + tblBooking.TimeBookingEnd) AS booking_end, tblRoom.Description, tblGroup.Contact, tblGroup.Phone FROM ((tblReservation LEFT JOIN tblBooking ON tblBooking.ReservationID = tblReservation.ID) LEFT JOIN tblGroup ON tblGroup.ID = tblReservation.GroupID) LEFT JOIN tblRoom ON tblRoom.ID = tblBooking.RoomID WHERE tblBooking.DateBooking >= now() ORDER BY tblBooking.DateBooking, tblBooking.TimeBookingStart; Jason Baird http://www.weboutsourcing.com 214-570-8336 ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
