Just in case anyone cares, the solution was replacing the WHERE line with
WHERE tblBooking.DateBooking >= DateAdd("d", -1, now())Thanks.
At 05:29 PM 4/3/2005 -0500, you wrote:
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
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
