I've not tested the below, but maybe it would work. Very cumbersome though and I'm wondering why the sql columns aren't standard date fields.
<cfquery datesource ="whatever" name ="lookup"> SELECT PA_START_DATE, PA_END_DATE FROM PA_TIMES </cfquery> <cfoutput query="lookup"> <cfset Qstartdate = #createdate(mid(lookup.pa_start_date,7,4),mid(lookup.pa_start_date,1,2), mid(lookup.pa_start_date, 5,2))#> <cfset Qenddate = #createdate(mid(lookup.pa_end_date,7,4),mid(lookup.pa_end_date,1,2), mid(lookup.pa_end_date, 5,2))#> <cfif #createdate(now())# gte qstartdate and #createdate(now())# lte #Qenddate#> Action </cfif> </cfoutput> -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 02:45 To: CF-Talk Subject: RE: SQL Dates ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226654 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
