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:261617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
