Focal Point
[SOLVED] Date Format in HEADER InfoAssist+

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

July 09, 2018, 11:37 AM
NewBee...WF8
[SOLVED] Date Format in HEADER InfoAssist+
I'm trying to achieve the date format using the report header in InfoAssist+, there is a function for time of day (&TOD). This displays the time as 11.12.25 (hours, minutes, seconds). Is there a way to display the time retrieved from the operating system as 11:12 AM for the &TOD function?

Thank you for your help in Advance.

Regards

This message has been edited. Last edited by: NewBee...WF8,


WebFOCUS 8
Windows, All Outputs
July 09, 2018, 12:47 PM
Hallway
Try using the variable &DATEHHIA instead of &TOD


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
July 09, 2018, 03:06 PM
NewBee...WF8
quote:
&DATEHHIA

Thank you Hallway, your solution worked just awesome.

Thank you


WebFOCUS 8
Windows, All Outputs
July 09, 2018, 06:44 PM
Hallway
Excellent. Glad to help.


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
July 10, 2018, 10:05 AM
David Briars
Thanks Hallway!

I've always known that with WebFOCUS System Variable &DATEfmt, fmt can be any date format.

I didn't know fmt could also be any date-time value.

Cool.

(What I love about the IT field, is that you 'learn something new every day'.)