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?
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day.
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…