I am looking to define a virtual field that combines a StartDate field (YYY-MM-DD) with a StartTime field (HH24:MM:SS) into one field. Then do the same with StopDate and StopTime fields. Finally I want to be able to substract StopDateTime from StartDateTime to get ElaspeTime in DD:HH:MM:SS format. Any Suggestions?This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8.009 Windows, All Outputs
January 23, 2014, 05:29 PM
Waz
Have you checked the H functions ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 24, 2014, 10:47 AM
Ian Dalton
As Waz said try the H functions - specifically HINPUT for part 1 and HDIFF for part 2. Chapter 7 of the the WF77dmfunctions.pdf is a good starting place.