Query Access Via Date Ranges

[Natesac]

Hey, crew... Just trying to figure out the best way to perform queries based on
certain date ranges

Example:

Let's say I want to pull all records that meet this criteria within 0-3months.
Should I create a variable to hold the current date and then do comparisons to
that? I would assume so, but don't know the correct syntax.

If anyone can help, it would be greatly appreciated.

Code Attached:

<cfquery name="getLeads" datasource="momlink">
SELECT Cust.FirstName, Cust.LastName, Cust.Odr_Date, Cust.Orderrec,
Cms.Order_st2
FROM Cust, Cms
WHERE Cust.Orderrec = Cms.Order
AND Cms.Ord_Total gt 0
AND Cms.Ord_Total <= 100
AND Cms.Sales_ID = '#UCase(GetAuthUser())#'
AND **WITHIN DATE RANGE**
</cfquery>

[Abinidi]

Do a lookup on DateDIff. That would allow you to compare dates in SQL.

[steveInCO]

SQL has a between expression. So you could calculate your start and end dates
in CF w/ DateDiff, then use them in the query

SELECT Cust.FirstName, Cust.LastName, Cust.Odr_Date, Cust.Orderrec,
Cms.Order_st2
FROM Cust, Cms
WHERE Cust.Orderrec = Cms.Order
AND Cms.Ord_Total gt 0
AND Cms.Ord_Total <= 100
AND Cms.Sales_ID = '#UCase(GetAuthUser())#'
AND Cust.Odr_Date BETWEEN #calculatedStartDate# and #calculatedEndDate#