Search results for query: *

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

Lupins46 That worked great. Thanks a Million 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 beleive there was a crupt dll in the program. I uninstalled , then re-installed and now it works great. Thanks for All your help. KKUB

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. . .

[;Chase Bank Transmit P.P. File Script for Procomm Plus ;***************************************************************************** ;* * ;* CHASE.WAS * ;*...

[;Chase Bank Transmit P.P. File Script for Procomm Plus ;***************************************************************************** ;* * ;* CHASE.WAS * ;*...

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.

No, the Zmodem transfer dialog box doesn't appear. The program just pauses.

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...