Jim, I started trying to understand the logic of the code and gave up, but it seems to work as written!
Thanks! Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, November 24, 2006 4:22 PM To: CF-Talk Subject: Re: How do I get number of birthdays? I think this will work...check the logic, though. WHERE ((Month(Client_Birth_Date) = #Form.Earliest_Birth_Month# AND Day(Client_Birth_Date) >= #Form.Earliest_Birth_Day#) OR Month(Client_Birth_Date) > #Form.Earliest_Birth_Month#) <cfif Form.Earliest_Birth_Month GT Form.Latest_Birth_Month> <!---This takes care of cases where the months go over a new year---> OR <cfelse> AND </cfif> ((Month(Client_Birth_Date) = #Form.Latest_Birth_Month# AND Day(Client_Birth_Date) <= #Form.Latest_Birth_Day#) OR Month(Client_Birth_Date) < #Form.Latest_Birth_Month#) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
