Search code examples
phpapidatetimefilemaker

Making a timestamp from 01-01-0001 to a given date/time

I have got an issue in which I am using the FileMaker PHP API which interacts with the FileMaker platform from the web.

My Issue is that the FileMaker Platform does not use the typical epoch but instead it uses a timestamp from 01-01-0001

Is there anyway to create a function which will generate a timestamp from 01-01-0001 to date('now'), for example?

Any help would be greatly appreciated.

Ps. I do understand PHP just fyi so I'm not a total newbie at PHP.

Solution

  • I think you want to get a PHP timestamp from a FileMaker timestamp. If this is correct, you can use strtotime on the data returned to you by the FileMaker PHP API.

    // Code that sets $record to a FileMaker_Record object
$timstamp = strtotime( $record->getField( 'timestamp_field' ) );

    If, on the other hand, you have a PHP timestamp an need to convert it to a FileMaker timestamp, you can use the date function with a format string as pointed out by Tim Dietrich.

    $user_update_request = $fm->newEditCommand('PHP_Users', $user->getRecordID());
$user_update_request->setField('Last_Login', date("m/d/Y h:i:s A"));
$user_update_result = $user_update_request->execute();