I built some pages including a search page using Homepage 3.0 to generate the CDML tags. All works fine execpt when I try to search for a date range. I only get the first date in the range. I seperated each date with ... and then I tried .. but no luck.

I have a similar problem when seaching for names in a pop-up. There are two Daves with different last names. When selecting one, both are returned in the search.

Any fix for these?

Thanks!

Dave

Some comprehensive threads exist here on date searches. Also, it will be worth your while to use the 'CDML Reference.fp5' database, which has information on tags and their parameters. It can be downloaded from the Filemaker site as a part of the 'CDML Tool' collection.

Also, relevent Filemaker Technotes exists on the www.filemaker.com web-site.

You may wish to look at using:

<input type="hidden" name="-op" value="eq">

or

&-op=eq&

piror to your person_name="Joe Smith" request.

Garry

Hi Gary,

Thanks for the quick reply. I searched this site prior to posting what I thought was a simple question. I found no answers relative to my inquiry.

As for the date ranges, it would be nice if there was a choice of "is between".

[ March 12, 2002, 03:10 PM: Message edited by: daviator ]

Dave,

This works for me:

http://localhost:1154/FMPro?-db=comb otest.fp5&-lay=listing&-format=showdates.html&-op=gt&last_app=1/1/2002&-op=lt&last_app=31/1/2002&-find

I'm using non US date format, however US date format should work it your computer is configured for it.

Hope this helps. All the best.

Garry

[ March 12, 2002, 04:49 PM: Message edited by: Garry Claridge ]

Hi Gary,

Pardon my ignorance but am I supposed to use the tags in the link above?

The link does not work.

The link is just an example using a url. A form version would look like this:

.

.

<input type="hidden" name="-op" value="gt">

<input type="text" name="mydatefield" value="">

<input type="hidden" name="-op" value="lt">

<input type="text" name="mydatefield" value="">

<input type="submit" name="-find" value="Find Records">

Hope this helps.

Garry

My standard reply:

USE THIS RESOURCE OFTEN.

http://www.filemaker.com/support/index.html

Search and read: Article Number: 104829, and Article Number: 105687

_____________

Plus a little more:

Understanding the use of the symbols of an exact search will enable you to uderstand how to use all the symbols available in the FMPro db find operation.

Remember that you are trying to get your format file to talk with your db file.

The biggest problem with the -op tag is that if you need two fields and data is entered in only one, your client will get a result. To avoid this you either need to understand the above or you need to know another language, JavaScript. This is not meant as a disparagement of JavaScript. I use it where appropriate.

I shouild have added that there are two threads this year, one started by Turansky and the other started by me. Both have currentdate in their thread title. You would be well advised to read these threads as well. One of those may well refer to an even earlier thread on range searches between two dates.