I have a database that I'd like to search the field "creation date" by a range. I know in FIlemaker its something like this.(ie. 08/01/2000..10/20/2000) but I can't figure out how to do it on the web. PLEASE HELP.

Thanks,

------------------

Rob Young

Rob!

this how to search for the range of dates:

put two date fields in HTML representaing the same FPM field.

Neat thing is to offer choice to user how it wants range defined (grather than, greater or equal, la,la,la)

Here is the sample code of how to do it. no copyright, as its mine let me know if it works

</P>

<CENTER>Date is<SELECT NAME="-OP">

<OPTION VALUE=eq SELECTED>is

<OPTION VALUE=gt>greater than

<OPTION VALUE=gte>greater than or equals

<OPTION VALUE=lt>less than

<OPTION VALUE=lte>less than or equals

<OPTION VALUE=neq>is not

</SELECT> <INPUT TYPE=text NAME=date VALUE="" SIZE=15> and

<SELECT NAME="-OP">

<OPTION VALUE=eq SELECTED>is

<OPTION VALUE=gt>greater than

<OPTION VALUE=gte>greater than or equals

<OPTION VALUE=lt>less than

<OPTION VALUE=lte>less than or equals

<OPTION VALUE=neq>is not

</SELECT><INPUT TYPE=text NAME=date VALUE="" SIZE=15></CENTER>

<P>