Why not just add subtract one day from the oldest date, then add one day to the newest date, THEN do a BETWEEN?
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, November 24, 2006 2:42 PM To: CF-Talk Subject: How do I get number of birthdays? Hi, all.yes, some of us are working today. I'm trying to output client info for clients who have birthdates between two designated months and days.not years. For example, I need to return all clients who have a birthday including and between Nov 27 and Dec 3, no matter what year. I tried where Month(Client_Birth_Date) >= '#Form.Earliest_Birth_Date#' and Day(Client_Birth_Date) >= '#Form.Earliest_Birth_Date#' and Month (Client_Birth_Date) <= '#Form.Latest_Birth_Date#' and Day (Client_Birth_Date) <= '#Form.Latest_Birth_Date#' and that code works (MySQL) when the birthdates fall in the same month, such as Nov 5 through Nov 12, but when the birthdates span two months, such as Nov 27 through Dec 3, the query returns no results. using "between" has been suggested, but I need to include birthdates on the dates specified, not just between them, and if I'm not mistaken, "between" would only return dates "between" the specified dates. Suggestions? Thanks, Rick PS - MySQL and CF 4.5 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
