cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Function to get offset of local time to UTC

Status: New Submitted by on ‎09-11-2023 10:26 PM
1 Comment (1 New)

What inspired this wish list request? 

I make several reports that run hourly on a server farm -- they output static reports via HTML files, and one way that I'd like to visually display if the report is stale is to have a short little JavaScript header that checks the creation time vs. the current UTC time (our company has users around the globe), and if older than 2 hours it'll turn the background red.

 

 

What is the improvement you would like to see? 

I'd like JMP to natively give the UTC offset of the local time-zone.  Currently I spin up a short little Python script in the AddinLoad file to determine it, but It'd be nice to have it be native

 

 

 

Why is this idea important? 

Having UTC offset can be handy when dealing with users across multiple time-zones.

 

1 Comment
Craige_Hales
Super User
Super User
‎09-12-2023 07:45 AM
‎09-12-2023 07:45 AM

Or a function to return UTC directly, and formats that understand how to present it for the current, or a specified, time zone. https://www.nhc.noaa.gov/aboututc.shtml

Working with time is hard, and UTC is the way to go for data that might be collected across time zones and years and DST changes that change according to local government whims. https://en.wikipedia.org/wiki/Time_in_Indiana