[FX.php List] Solved? Anyone got a sober solution to a date range search?

[Tim 'Webko' Booth]

On 11/08/2008, at 8:49 PM, Gjermund Gusland Thorsen wrote:

> I know this worked with Filemaker 5/6
> ---
> $q = new FX( $serverIP, $webCompanionPort );
> $q->SetDBData( $database, 'unit', 'all' );
> $q->AddDBParam( 'datefield', '1/7/2008...31/7/2008' );
> $r = $q->FMFind();
> ---
>
> But what is the FileMaker 7/8/9 equivalent on the XML RPC level to
> FileMaker's: 1.7.2008...31.7.2008 ?
>
> :-) Hmm it looks like this works! :-) I just played around with the
> characters and numbers.
> ---
> $q = new FX( $serverIP, $webCompanionPort );
> $q->SetDBData( $database, 'unit', 'all' );
> $q->AddDBParam( 'datefield', '7.1.2008...7.31.2008' );
> $r = $q->FMFind();

Underneath it all, no matter what your localisation settings, all  
dates are now stored MM/DD/YYYY and searches need to be adjusted  
accordingly