I have a database with holiday dates in it. I have a date (duedate) and I
want to see if duedate has a holidaydate between now and duedate. I also
want to see if the duedate lands on a holiday. If there is a holiday then I
want to subract 1 day from duedate. Shouldn't this give me what I need?
<CFLOOP QUERY="GetHolidaydate">
<CFIF ((DateCompare(DATEDUE,
"#CreateOdbcDate(holiday_date)#") IS 1) AND
(DateCompare(NEWDATE,
"#CreateOdbcDate(holiday_date)#") IS -1)) OR
(DateCompare(DATEDUE,
"#CreateOdbcDate(holiday_date)#") IS 0)>
<CFSET NEWDATE3 = "#DateAdd('D', -1,
DATEDUE)#">
</CFIF>
<CFIF DAY IS "Sunday">
<CFSET DATEDUE =
"#DateAdd('D', -2, DATEDUE)#">
</CFIF>
<CFIF DAY IS "Saturday">
<CFSET DATEDUE =
"#DATEADD('D', -1, DATEDUE)#">
</CFIF>
<!--- QUERY FOR A HOLIDAY COUNT --->
<CFQUERY
DATASOURCE="#application.lldbDatasource#" name="GetHolidayCount">
select count(1) hlday_cnt
from ll_holiday
where
#CreateOdbcDate(holiday_date)# = #CreateODBCDate(DATEDUE)#
</CFQUERY>
<CFIF GetHolidayCount.hlday_cnt EQ
"1">
<CFSET DATEDUE =
"#DATEADD('D', -1, DATEDUE)#">
</CFIF>
</CFLOOP>
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
