GetCurrentTimeZoneUTCOffset ( )

Returns a number that is the current timezone's UTC offset

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

GetCurrentTimeZoneUTCOffset ()

Sample output:

-7

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

/*
 *  CUSTOM FUNCTION
 *    GetCurrentTimeZoneUTCOffset ( )
 *
 *  DESCRIPTION
 *    Returns a FileMaker time that's the offset from UTC + 0 from the current timestamp
 *    There is odd behaviour with webdirect. Get ( CurrentTimestamp ) can be a few min off from Get ( CurrentTimeUTCMilliseconds )
 *    Because of this, when the hour rolls over for one but not the other, unless we check for this, it will return the wrong number
 *
 *  PARAMS
 *    --NONE--
 *
 *  RETURNS
 *    Time
 *
 *  DEPENDANCIES
 *    GetCurrentUTCTimestamp
 *
 *  CHANGELOG
 *    2021-03-10: Paul McCudden: Created
*/

Let (
    [
        ~tsLocal = Get ( CurrentTimestamp );
        ~tsHourLocal = GetAsNumber ( GetAsTime ( ~tsLocal ) ) / 3600;
        ~hourDecimalLocal = GetAsNumber ( GetAsTime ( ~tsLocal ) ) / 3600 - Int ( GetAsNumber ( GetAsTime ( ~tsLocal ) ) / 3600 ) ;
        ~tsUTC = GetCurrentUTCTimestamp;
        ~tsHourUTC = GetAsNumber ( GetAsTime ( ~tsUTC ) ) / 3600;
        ~round = ~hourDecimalLocal > .75 or ~hourDecimalLocal < .25
    ];

    GetAsTime (
        Timestamp ( 
            Date ( Month ( ~tsLocal ); Day ( ~tsLocal ); Year ( ~tsLocal ) );
            Time ( If ( ~round; Round ( ~tsHourLocal; 0 ); Floor ( ~tsHourLocal ) ); 0; 0 )
        ) -
        Timestamp ( 
            Date ( Month ( ~tsUTC ); Day ( ~tsUTC ); Year ( ~tsUTC ) );
            Time ( If ( ~round; Round ( ~tsHourUTC ; 0 ); Floor ( ~tsHourUTC ) ); 0; 0 )
        )
    )

)

Returns a FileMaker time that's the offset from UTC + 0 from the current timestamp

There is odd behaviour with webdirect. Get ( CurrentTimestamp ) can be a few min off from Get ( CurrentTimeUTCMilliseconds )
Because of this, when the hour rolls over for one but not the other, unless we check for this, it will return the wrong number

Comments

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

GetCurrentTimeZoneUTCOffset ( )

Comments

Support this website.

Support this website.