Select Box Date

[ewylam]

How can I have selection boxs within a form only show dates that are in between two dates pulled from a database? Any suggestions?

 

[TruthInSatire]

you tell your query to only bring back the dates you want.

<cfquery name = "qListDates" datasource = "yourDataSource">
SELECT yourDate
FROM tableName
WHERE yourDate bewteen ##1/1/04## and ##1/1/05##
</cfquery>

notice the ## you need them to tell cf you only want one real # there. date fields are often wrapped in #'s

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[Sarky78]

Is this the sort of thing you are looking for:

<CFSET Request.DateStart = "12/12/2004">
<CFSET Request.DateEnd = "12/25/2004">


<select name="StartDay">
<CFLOOP FROM="#Day(Request.DateStart)#" TO="#Day(Request.DateEnd)#" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>

<select name="StartMonth">
<CFLOOP FROM="#Month(Request.DateStart)#" TO="12" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>

<select name="StartYear">
<CFLOOP FROM="#Year(Request.DateStart)#" TO="#Year(Request.DateEnd)#" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>
<BR><BR><BR><BR>
<select name="EndDay">
<CFLOOP FROM="#Day(Request.DateStart)#" TO="#Day(Request.DateEnd)#" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>

<select name="EndMonth">
<CFLOOP FROM="#Month(Request.DateEnd)#" TO="12" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>

<select name="EndYear">
<CFLOOP FROM="#Year(Request.DateEnd)#" TO="#Year(Request.DateEnd)#" INDEX="i">
	<option value="<CFOUTPUT>#i#</CFOUTPUT>"><CFOUTPUT>#i#</CFOUTPUT></option>
</CFLOOP>
</select>

Hope this helps!

Tony

 

[ewylam]

Awesome Tony. Thanks alot that was perfect.