one date relative to another
Posted on 2001-06-18
I have a date field called 'expires' and I need to find out if it is within a month of now. This is as far as I've got so far:
<CFQUERY DATASOURCE="marketing" NAME="GetRenewals">
SELECT * FROM client_info
expires <= #fromdate#
ORDER BY expires ASC
but obviously I gotta change something in the fromdate. I tried month(now(1)) and month(1()) but no joy. can anyone tell me what I'm doing wrong?
low on points, hence only 50...