Never mind...figured out that I needed to leave off the year to get birthdates...years don't matter...
Thanks... Rick -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 10:47 AM To: CF-Talk Subject: How can I make this query run correctly? Good morning, all. I'm having to directly query a MySQL database for a client because they can't access their web app on my server. I'm trying to get clients' whose birthdates fall with a date range. I've tried variations, with no success in returning *any* results. the latest version of the query is as follows: Select Client_First_Name, Client_Middle_Name, Client_Last_Name, Client_Street_Address, Client_City, Client_State, Client_Zip_Code, Client_Birthdate from clients where Client_Birthdate >= '2006-11-27' and Client_Birthdate <= '2006-12-31' Is it a date formatting issue? Is so, what is the date date format MySQL could read? Thanks for any help! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4