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

[Kevin Futter]

On 10/5/07 12:50 PM, "Derrick Fogle" <derrick at fogles.net> wrote:

>> the server OS, and I suspect one we missed is the time/date format.
>> I suspect that FSMA on this machine is using the system settings,
>> but we bungled them! AFAICT you can¹t set it afterwards like on the
>> client OS, just like you can¹t change its status from stand-alone to
> 
> This discussion has come up on the list before. AFAIK, the FMPXML API
> is just plain stuck in American date format. Even if the rest of the
> install is working properly for other date formats, the XML API will
> still only take, and return, the American mm/dd/yyyy. For anything
> besides that, you'll need to use PHP to coerce date formats.
> 
> $eurodate = date("d/m/Y",strtotime($americandate));
> $americandate = date("m/d/Y",strtotime($eurodate));
> 
> 
> Derrick Fogle
> derrick at fogles.net

The curious thing is, it was never a problem on FMU, or on our FMSA test box
(G5 with client OS). All dates went in and came out as expected. You can't
help feeling like Alice in Wonderland with this stuff sometimes.

-- 
Kevin Futter
Webmaster, St. Bernard's College
http://www.sbc.melb.catholic.edu.au/


#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

This e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. The College does not guarantee that this e-mail is virus or error free.  The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this e-mail are not necessarily those of the College.