TimeLocalOffsetHours ( options )

Returns the local offset (in hours) from UTC.

Be the first to rate this function Log in to vote

Dan Shockley - Show more from this author

Sample input:

TimeLocalOffsetHours ( "" )

Sample output:

-5

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

// TimeLocalOffsetHours ( options )
// version 2023-01-30

/* 
	Returns the local offset in hours from UTC. Default is to fractional hours (one decimal place to support half-hour time zones). 
	Useful when used in combination with other time conversion functions, e.g. time.UTCtoLocal, by Rob Poelking, https://www.briandunning.com/cf/1161

HISTORY:
	2023-01-30 ( dan@GothamDataWorks.com ): Renamed to "TimeLocalOffsetHours" instead of "TimeLocalOffset" for clarity. 
	2023-01-10 ( dan@GothamDataWorks.com ): First created. Not yet any options, but put that in place for future possible use. 
*/


Let ( [ 
	  myOffsetTime = Get ( CurrentTimestamp ) - GetAsTimestamp ( Round ( Get ( CurrentTimeUTCMilliseconds ) / 1000 ; 0 ) )
	; myOffsetHours = Round ( myOffsetTime / 3600 ; 1 )   /* one decimal place so it works for half-hour time zones */
]; 

	myOffsetHours

)

Returns the local offset in hours from UTC.
It compares the machine's local time to that returned by the native FileMaker function CurrentTimeUTCMilliseconds, then converts that to hours, keeping one decimal place in order to support half-hour time zones.
No dependencies, but can be used in combination with other time conversion functions to added to their usefulness. For example, can be used for the "time.UTCtoLocal", by Rob Poelking, found at https://www.briandunning.com/cf/2058

Comments

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

TimeLocalOffsetHours ( options )

Comments

Support this website.

Support this website.