Something

public text v1 · immutable

#756812

·published 2007-10-31 19:23 UTC

<cfset dteDatePass=#CreateDate(FORM.year_var,FORM.month_var,FORM.day_var)#>
<cfset dteEndDate=#DateAdd("d",14,dteDatePass)#>

<cfquery datasource="#sDSN#" name="qEvents">
SELECT *
FROM ach_time
WHERE (date_today BETWEEN '#DateFormat(dteDatePass, 'mm/dd/yyyy')#' AND '#DateFormat(dteEndDate, 'mm/dd/yyyy')#') AND user_id='#FORM.user_id#'
ORDER BY date_today
</cfquery>