Focal Point
[CLOSED] Date Time Handling

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8427088666

January 23, 2014, 05:16 PM
Dave H.
[CLOSED] Date Time Handling
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.


_______________________
*** WebFOCUS 8.1.05M ***