I am trying to adjust my web pages to work with FM Sever Advanced 7 and FX.

I need to find records within particular date range. I was able to do that with FMPro6. Right now I can FindAll, or use -eq without any problems, but the follwong does not work:

$fmq->AddDBParam('date1', $start_date, 'gte');

$fmq->AddDBParam('date2', $end_date,'lte');

$fmq->AddSortParam('work_number', 'ascend');

$ReturnedData = $fmq->FMFind();

I believe all my other settign are OK because I can FMFind records for one date. What is not wokring is finding the date range.

Please HELP...

Thank you!

Sorry, it is

$fmq->AddDBParam('date1', $start_date, 'gte');

$fmq->AddDBParam('date1', $end_date,'lte');

I am searching on the same field..:

Is it working OK with the same query directly into FM, or even as a URL with XML being returned?

Garry

It is working OK directly in FM.

It returns 0 when I am trying to do the following:

http://localhost/fmi/xml/FMPXMLRESULT.xml?-db=test.fp7&-lay=web&date_entered=12/18/2004&date_entered.op=gte&date_entered=12/19/2004&date_entered.op=lte&-find

Thank you!

I figured out that this works thought:

http://localhost/fmi/xml/FMPXMLRESULT.xml?-db=test.fp7&-lay=web&date_entered=12/11/2004...12/18/2004&date_entered.op=bw&-find