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

[Michael Ward]

Hi Roger & Keith,

> We have a similar problem in that since upgrading to FMSA v8 for  
> production (which involved setting up an Xserve from scratch), our  
> dates all come out of the db in the US format, despite being  
> entered into the database as mm/dd/yyyy. For display purposes I  
> just manipulate it with PHP, but I still can’t figure out why it’s  
> doing it, other than some mysterious server setting (FM or OS X)  
> that we neglected to configure at setup time.

It's the way FileMaker sends dates... it is _always_ in the US  
format, no matter how it is displayed/entered.

I use this PHP code to display it the way I want it (probably similar  
to yours Keith)

echo date('j/n/Y',strtotime(yourDateValueFromFX))

Regards

Michael Ward
--
Head Honcho
CustoMike Solutions
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker 7 Certified Developer
FileMaker 8 Certified Developer
10 Wandoo Crt
Wheelers Hill, 3150
ph 0414 562 501
headhoncho at customikesolutions.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070510/d664ebd9/attachment-0001.html