I have found the following formula works globally to convert Julian dates to Standard dates in excel.
=Date(1900+(LEFT(TEXT(Your date,"000000"),3)),1,RIGHT(Your Date,3))
KKUB
I have converted time in seconds to a 24 hour clock format.
I tried to use the format constant to change the format to "XX:XX"
StrTotaltime: Format([HRS] & [Min],"nn:nn")
When I used the above the output displays 00:00 and doen't include the values from [HRS] and [MIN]. Where have I gone wrong?
I am attempting to reformat the time in an Oracle database which is currently in Seconds to a standard 12 hour clock time.I successfully convert secondes into two field with correct 24 hour clock Hrs and Min.
Example "Hrs= 6", "Min = 0"
I used StrTotaltime: Format([HRS] & [Min],"nn:nn") the...
If you are at V5R2, you can use Iseries Navigator.
Click on Basic Operation, then printer output and select your output. Drag the icon to windows explorer Your done!
I am attempting to use a Sub-file Diplay program to pass Data to a Visual Basic Application. I want to send data thru a Data Area . The problem, I'm trying the run the RPG display file WITHOUT displaying any data. Anyone have any thoughts on how to acheive this?(Basicly using a display pgm to...
I recently changed my Oracle server to run under a Active directory domain server. After changing O-server, I was unable to contact it thru the oracle client pc. "Unable to contact database" Do you know any Trade secrets to make this transition?
I tested with the usermsg"test" and the message did display
I moved the user message down in the code to
[sendfile ZMODEM "013004TranF.txt] and still the message displayed. Help. . .
The script works only stoping after [waitfor "The current File Transfer Protocol is ZMODEM."] line in the code. Afterward no other line of code works.
I am unable to get the procomm software to upload file after it connects to the number. The script just stops.
Below is the code I used. Help . . .
;* CHASE.WAS *
;* Copyright (C) 2000 - 2010 Ametek Aerospace...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.