The field JSSCHSTTIME in F91320 stores the Scheduled Start Time in UTC format e.g. value 18698955. This is a Local Date and Time format of 2005-07-21  17:15:00

JSSCHSTTIME stores the UTC time. UTC stands for Universal Time Coordinate and is a long integer containing the elapsed minutes since Midnight on January 1, 1970 in Greenwich, England.

Now lets write some code which would help converting timezones, from and to. Similarly use UTC time zone and its format effectively for Multi-Location Projects/softwares. But before hand make sure daylight saving rules (DST) are set up correctly in P00085 application. This is applicable only for countries observing DST. The Event rules (ER) along with the screen shot of the app done is given below.

Listing of ER for Application : Test for UTC Timezones (P550003)
==================================
FORM: Fix/Inspect [FIX INSPECT] (W550003A)
==================================
CONTROL: FORM
EVENT: Post Dialog is Initialized
-----------------------------------------
// Retrieve the Current UTC Time into a Long Integer Variable
Get Current UTC Time
     VA frm_SchStartTime_SCHTTIME <- BF mnCurrentUTCTime
// Display UTC Time
FC UTCTime_UTIME = utc_get_cur_time()

-----------------------------------------------------------------------
CONTROL: BUTTON Convert EVENT: Button Clicked
-----------------------------------------------------------------------
// Get the Local Time from UTC TimeZone
Get Time and Date From UTC
     VA frm_SchStartTime_SCHTTIME -> BF mnUTCTime
     FC Time Last Updated <- BF mnTime
     FC Date Updated <- BF jdDate
     "2" -> BF cUTC_Local
     "14" -> BF szTimeZone
//
//
// Format the Time into hh:mm:ss
Format MathNumeric to Time String
     FC Time Last Updated -> BF mnTime
     FC FormattedTime <- BF szTime
     "Zero"-> BF cFormatMode

Call Business Function “Get Time and Date From UTC” – B9800009
This function can be used to return the date and time for a UTC time in Local Date and Time format.

Get Time and Date From UTC
“18698955″ -> mnUTCTime
VA frm_SchedulerStartTime_SCHSTTIME <- mnTime
FC Scheduled Start Date <- jdDate
“2″ -> cUTC_Local            /* 2 stands for Local Time.   1 stands for UTC time  */
“14″ -> szTimeZone          /* Check UDC H91/TZ for your country time zone. “14″ is Indian Standard Time Zone */

Help From: Customer Connection Solution 200999495

Related Articles:

1. EnterpriseOne 9.0 Standalone – Oracle Local Database Login Credentials
2. Using BSFN to Delete All Records from a Table
3. Value of SV File_IO_Status in Table IO
4. Identify UBE Versions with Overrides
5. Free tool for viewing / testing JDE Objects