Nice try... but it's a no go... It works the same way as before.
This is just too odd... for it to have worked fine for a day, then the next day, without any changes, it begins to return different results. I guess I can always default the Earliest_Birthdate_Day to 1 and Earliest_Birthdate_Month to Jan and Latest_Birthdate_Day to 31 and Latest_Birthdate_Month to Dec... That way, if no changes are made to those fields, all client records will be returned. Thanks for your help Jim! Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, November 25, 2006 9:57 PM To: CF-Talk Subject: Re: How do I get number of birthdays? Rick, See above...I added in parentheses to group the birthdate stuff, so that it is evaluated together. The way you had it before you could have possibly had all (or any) of the parameters evaluate to false, but if the earliest month was greater than the latest month, that OR would have made it so records would be returned if that last part about the latest birthdate was true. Hopefully that makes sense...it's kind of hard to explain without pointing at it. Anyway, that is the only thing I can think of that would cause what you are describing. -jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
