Brian Dunning's FileMaker Custom Functions

epochTime

Returns epoch time ( aka: Unix, POSIX timestamp GMT +0 )

  Average rating: 5.0 (2 votes) Log in to vote

bigtom   bigtom - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
epochTime
  Sample output:
1609879711

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

No parameters. Uses Get ( CurrentTimeUTCMilliseconds ) with an offset constant 62135596800 which is the number of seconds between 1/1/0001 and 1/1/1970.

Timestamp returned is GMT +0 (UTC) and this works for local and hosted files just the same.
There are some other more complicated implementations of this, but this is about as simple as I could get it so it evaluates as quickly as possible. No time offset required.

 

Comments

Kyle Williams   Kyle Williams, Dreamclinic Massage
Jan 6, 2021
FYI: Epoch Time = Unix time... Not sure why you didn't include a parameter and have an option to leave the parameter empty to default to the current time? I think that would have made this Epoch/Unix time function a little more useful.
 
bigtom   bigtom
Jan 6, 2021
Kyle, This is intended to evaluate the timestamp in the most efficient way possible at the time the function is invoked. The use of any parameters was specifically left out, but I do use the same CF with a parameter and it is also quite useful.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: