I thought I might have gotten it to work, but I was incorrect.
There are 5 cases in table. Today is August 2nd. I dated 4 cases with dates
of 8/4/2002 to simulate 2 days from due date. 1 case is dated 7/31/2002 to
simulate over due.
The results I am getting are as follows:
1 cases are overdue. CORRECT
2002-07-31 00:00:00
1 cases 2 days from due date. HUH???
2002-07-31 00:00:00
4 cases 2 days from due date. CORRECT
2002-08-04 00:00:00
Here is what I have so far.
--------------------------------------------------------------------------
<cfquery name="OverDue" datasource="lsar_dev">
select due_date, count(due_date) AS overduecount
from dbo.tbl_open_cases
group by due_date
</cfquery>
<cfquery name="OpenCases" datasource="lsar_dev">
select due_date, count(due_date) AS opencasescount
from dbo.tbl_open_cases
group by due_date
</cfquery>
<cfloop query="Overdue">
<cfif due_date LT Now()>
<cfoutput>#overduecount#</cfoutput> cases are overdue.
<cfoutput>#due_date#
</cfoutput>
</cfif>
</cfloop>
<cfloop query="OpenCases">
<cfif #Abs(Datediff("d",Now(),due_date))# LTE 2>
<cfoutput>#opencasescount#</cfoutput> cases 2 days from due date.
<cfoutput>#due_date#
</cfoutput>
</cfif>
</cfloop>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
