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

Kevin Futter kfutter at sbc.melb.catholic.edu.au
Wed May 9 17:28:23 MDT 2007


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070510/81e72d07/attachment.html


More information about the FX.php_List mailing list