Name | Value | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NUMBER | 6445 | |||||||||||||||||||||||||
IA # | 6445 | |||||||||||||||||||||||||
DATE CREATED | 2016/08/05 | |||||||||||||||||||||||||
CUSTODIAL PACKAGE | VA FILEMAN | |||||||||||||||||||||||||
USAGE | Supported | |||||||||||||||||||||||||
TYPE | Routine | |||||||||||||||||||||||||
DBIC APPROVAL STATUS | APPROVED | |||||||||||||||||||||||||
ROUTINE | DIUTC | |||||||||||||||||||||||||
NAME | DIUTC | |||||||||||||||||||||||||
GENERAL DESCRIPTION | This Coordinated Universal Time (UTC) API will convert a FileMan date/time into Greenwich Mean Time (GMT) with a time zone offset based on various input values entered by the user or the default institution in the DUZ(2) variable. The format of the default output will be a GMT represented in standard FileMan date/time format and an internal three digit time zone offset appended to the end. The calculation for the internal offset is the external offset converted to minutes, then divided by 5, and then added to 500. So -07:00 is -420 minutes, then divided by 5 is -84, and added to 500 is 416. There may be other output variables based on the value of the EXT input parameter. The details for the other output values are documented in the $$UTC variable below. To determine the offset, the API needs to have a TimeZone and Country. These values are determined using the following algorithm: 1. No optional input parameters are passed in. The user's default Institution will be used based on the DUZ(2) variable. The TimeZone and Country are determined by the new fields in the Institution file. 2. If only Institution is passed in as an input parameter, the TimeZone and Country are determined by the new fields in the Institution file. 3. The TimeZone and Country parameters are both passed in as input parameters. The UTC API will return an error for any of the following conditions: 1. If the TimeZone or Country cannot be determined from any of the methods documented above, an error will be returned. 2. If the TimeZone parameter is passed in without Country parameter or the Country parameter is passed in without a TimeZone parameter, an error will be returned. 3. If the Institution parameter is passed in with either the TimeZone or Country parameter, an error will be returned. 4. Once the TimeZone and Country are determined, they will be validated for consistency. An error will be returned if they are inconsistent e.g. if user passes in TimeZone = "Australian Eastern Time" and Country="Mexico", the UTC API will return an error. |
|||||||||||||||||||||||||
STATUS | Active | |||||||||||||||||||||||||
KEYWORDS |
|
|||||||||||||||||||||||||
DURATION | Till Otherwise Agreed | |||||||||||||||||||||||||
ID | DIUTC | |||||||||||||||||||||||||
COMPONENT/ENTRY POINT |
|
|||||||||||||||||||||||||
DATE ACTIVATED | 2017/06/23 |