Rick Faircloth wrote:
> Good morning, all.
>
> I'm having to directly query a MySQL database for a client
> because they can't access their web app on my server.
>
> I'm trying to get clients' whose birthdates fall with a date range.
>
> I've tried variations, with no success in returning *any* results. the
> latest version of the query is as follows:
>
> Select Client_First_Name, Client_Middle_Name, Client_Last_Name,
> Client_Street_Address, Client_City, Client_State,
> Client_Zip_Code, Client_Birthdate
> from clients
> where Client_Birthdate >= '2006-11-27'
> and Client_Birthdate <= '2006-12-31'
>
> Is it a date formatting issue? Is so, what is the date date format MySQL
> could read?
>
This is a guess, but perhaps...
WHERE Client_Birthdate >= CAST('2006-11-27' AS DATE) AND
Client_Birthdate <= CAST('2006-12-31' AS DATE)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:261422
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
