I have a date time field in an Access 2000 database.
Looks like this on the SearchFrom.cfm:
<FONT COLOR="Navy"><B><FONT FACE="Arial">Search by Day</FONT></B></FONT><BR>
<INPUT TYPE="Text" NAME="bDay" size="20" maxlength="50">
</P>
<!--- submit button --->
<p>
<INPUT TYPE="Submit" NAME="SubmitButton" VALUE="Search Schedule">
Dates are entered as 5/25/2001 and then I format/output them to
May 25, 2001 Friday
On the SearchAction.cfm I would like to be able to search for "May" or
"July". Right now I search on "5" and I get May.. but I also get June 25 and
December 25 <G>
Here is the CFIF I use to search on "5". How do I change this to search for
"May"?
<CFIF IsDefined("Form.bDay") IS "YES">
<CFIF Form.bDay IS NOT "">
AND bGames.bDay
LIKE '%#Form.bDay#%'
</CFIF>
</CFIF>
Thanks!
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
