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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists