Shopping Cart
Contact
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
Unix_Date ( current_timestamp ; time_zone_offset ) Rate this function:   Discuss this Custom Function Tony Moller, DCWerks, LLC Calculates the Unix Epoch Date
Description:Calculates the Unix timestamp, which is the number of seconds from 1/1/1970. If you use FileMaker's Get (CurrentTimeStamp) function to send the timestamp to the Unix_Date function, make sure you set the time_zone_offset to your local time zone (-5 is EST, -4 is EDT). Setting time_zone_offset to 0 (zero) will treat the timestamp as GMT. Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems. This is my Custom Function and I want to edit it Discuss:Can you use this unix epoch date to regenerate an accurate timestamp? p10, Vancouver Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
A simpler method that accomplishes the same purpose (unless I am missing something) is as follows (where _timestamp and _hourOffset are the function parameters):
Let ([
min = GetAsTimestamp ( Date ( 1 ; 1 ; 1970 ) ) ;
max = GetAsTimestamp ( Date( 7 ; 8 ; 2038 ) )
];
If ( _timestamp ≥ min and _timestamp ≤ max;
GetAsNumber ( _timestamp ) - GetAsNumber ( min ) - ( _hourOffset * 3600 )
;
-1)
)
Kevin Vile, Ohio
July 20, 2010 6:58am