check ur birthday
Posted on 2001-06-29
i need to implement a function which could check for customer birthday
let say i store the DOB in date format, dd-mmm-yyyy in database
i plan to use query to extract the birthday within two week, so
the query will be something like this:
<cfquery name="DOBcheck" datasource="profile" dbtype="ODBC">
where cust_dob-now() <= 14 AND cust_dob-now()> 0
order by cust_dob
but the problem is the comparation is include "year"
if i just wanto compare using day and month,
like "1 Jul" display, since it is within condition range)
how the condition *** wil look like?