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

[Dale Bengston]

Isn't there someplace you set FMP to "use system settings" or  
something? Being in the Ugly American camp, I've never had to adjust  
for conventions on other continents, so I'm sorry I can't quote  
chapter and verse.

Dale

On May 9, 2007, at 6:28 PM, Kevin Futter wrote:

> On 10/5/07 9:15 AM, "Michael Ward"  
> <headhoncho at customikesolutions.com> wrote:
>
>> 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))
>>>
>>
> Really? It wasn’t like that at all on our G5 test box, only when we  
> rebuilt the Xserve and moved FMSA across to it.  And it certainly  
> wasn’t like that with FMU6 prior the upgrade either.  Thanks for  
> the code example too, I think I’m doing it the hard way (splitting  
> the string, chopping it around etc).
>
> -- 
> 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.
> _______________________________________________
> 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/21968f5e/attachment-0001.html