Focal Point
[SOLVED] Format Hour to Integer

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

July 13, 2018, 05:38 AM
jenni
[SOLVED] Format Hour to Integer
Hi,

how can I Change the Format from Hour(HH) into Integer, sothat I can use the new integer Hour in an Graph as Y Axis??

Thanks.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05
Windows, All Outputs
July 13, 2018, 08:12 AM
MartinY
One way could be the below assuming the HRS format is HH

DEFINE FILE ABC
HRSD/I2 = EDIT(FPRINT(HRS, 'HH', 'A2'));
END



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 13, 2018, 12:59 PM
Doug
What's the format of the incoming field?
Example in DM:
-SET &HourInt = EDIT(&TOD,'99');
or DEFINE:
HourInt/I2 = EDIT('&TOD.EVAL','99');
Or, as MartinY suggested, Depending on the incoming field and how you want to do it. I hope this helps.