Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4   11.5   11.6    Statistic    FMM    Blog  


Returns the unix time stamp.

Component Version macOS Windows Linux Server iOS SDK
Utility 3.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Time.UnixTimeStamp" { ; timestamp; gmt } )   More


Parameter Description Example Flags
timestamp Optional, a FileMaker timestamp to convert. Get(SystemTimeStamp) Optional
gmt Available in MBS FileMaker Plugin 10.3 or newer.
Whether to use GMT as time zone.
Pass 1 for GMT or 0 for local.
Not used if you query now, e.g. without a timestamp.
0 Optional


Returns time stamp as number.


Returns the unix time stamp.
If called with no parameters, returns current time stamp (GMT).
If you pass a timestamp, this timestamp is converted. Be aware that the system timezone is used.

Convert back to FileMaker with Time.UnixTimeStampToFileMaker function.


Calc current time:

MBS( "Time.UnixTimeStamp"; Get(CurrentTimeStamp) )

Example result: 1481452626

Calc time for date:

MBS( "Time.UnixTimeStamp"; Date ( 5; 5; 1956 ); 0 )

Example result: -431053200

Calc time for date in GMT:

MBS( "Time.UnixTimeStamp"; Date ( 5; 5; 1956 ); 1 )

Example result: -431049600

Calc current time:

MBS( "Time.UnixTimeStamp" )

See also

Release notes

Example Databases

Blog Entries

Created 18th August 2014, last changed 26th February 2021

Time.TimeZoneOffset - Time.UnixTimeStampToFileMaker

Feedback: Report problem or ask question.

MBS Xojo PDF Plugins

Start Chat