Jump to content
Server Maintenance This Week. ×

? Search range of Date field on web.


This topic is 8626 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

  • 2 weeks later...
  • Newbies

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 smile.gif 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>

Link to comment
Share on other sites

This topic is 8626 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.