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:
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
Returns the unix time stamp.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
Utility | 3.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
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.
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" )
Created 18th August 2014, last changed 26th February 2021
Time.TimeZoneOffset - Time.UnixTimeStampToFileMaker
Feedback: Report problem or ask question.