Thanks, Andy...that was going to be my next approach. Jim's solution took care of it for me, however... it took care of the need to include the dates the user specified, plus crossing over between years.
Rick -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, November 27, 2006 9:20 AM To: CF-Talk Subject: RE: How do I get number of birthdays? 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 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
