Formatting FileMaker TimeStamp Values with PHP
Have you ever needed to display a FileMaker TimeStamp field value in a PHP solution? If so, you might have run into problems with making the value format nicely.For example, suppose that you have a timestamp field named "DateTime_Created" with a value of "7/30/2009 9:18:29 PM." If you simply echo the value using PHP code such as...echo $response->getField("DateTime_Created");... then the outputSetting FileMaker TimeStamp Fields from PHP
Want to update a FileMaker Timestamp field with the the current date/time via a PHP solution?Use the PHP date function and format it using something like this: date("m/d/Y h:i:s A")For example, suppose that you want to update a "Last_Login" field when a user logs in. Your code might look something like this:$user_update_request = $fm->newEditCommand('PHP_Users', $user->getRecordID());$Connecticut FileMaker Developer Group
I had a great time at the monthly meeting of the Connecticut FileMaker Developers Group. We met at the usual location: the Student Center at Central Connecticut State University in New Britain.
The main topic was a discussion of online resources for the FIleMaker developer. These include custom function lists, forums and the official FileMaker bug tracker among others.