Newbies GTiRob Posted September 14, 2000 Newbies Posted September 14, 2000 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
Newbies Vujone Posted September 27, 2000 Newbies Posted September 27, 2000 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>
Recommended Posts
This topic is 9091 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 accountSign in
Already have an account? Sign in here.
Sign In Now