[FX.php List] Find record using 'date'

[Roger Price]

Dan

I was a bit non-plussed by Gjermund's rather enigmatic comment "The formating of the date is essential " as it was not clear in which way - in the source or in the request or both - and how should the formatting be done?

I have pulled across the dates from my FMP database which seemed to arrive as 'dd/mm/yyyy' (which was how they had been entered) however when I send then in that format via an FX.php 'find' request with debug turned on it seems that they are being URL encoded. Could this be the problem?

Not having a solution I decided to 'find all' and manipulate the data with PHP. This didn't work as expected either and found that although I was entering 'dd/mm/yyyy' I was actually getting 'mm/dd/yyyy'. 

Now I'm not sure what the problem is!

I have achieved my goal by 'brute force' with PHP but would still like to undersatnd how to craft a request in FX.php.

Dates do seem to be a bit of  a minefield. 

kindest regards

Roger


----- Original Message ----- 
From: "DC" <dan.cynosure at dbmscan.com>
To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
Sent: Wednesday, May 09, 2007 3:35 PM
Subject: Re: [FX.php List] Find record using 'date'


> did you try typing this by hand: "1/12/2006...24/12/2006"
> 
> what is left in the fmp field after the PHP find request is done? do 
> "refind" command-R to see what FX.php sent to  FMP.
> 
> dan
> 
> 
> Gjermund Gusland Thorsen had written:
>> The formating of the date is essential.
>> 
>> ggt667
>> 
>> On 5/9/07, Roger Price <rp272 at cam.ac.uk> wrote:
>>>
>>>
>>> Just when I thought I was getting the hang of this...
>>>
>>> I have an FMP date field 'dd/mm/yyyy' and want to do a find between a 
>>> range
>>> of dates. It works when in native Filemaker but I get a zero 'foundcount'
>>> when I use FX.php.
>>>
>>> Is there some trick to this?
>>>
>>> TIA
>>>
>>> Roger
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070509/69954c39/attachment-0001.html