Focal Point
[SOLVED] Formatting Timestamp

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

March 07, 2011, 01:53 PM
Jason K.
[SOLVED] Formatting Timestamp
Is it possible to format just the time out of a timestamp field?

Using report painter it generates
START_PROJECTED/HYYMDI
which shows up as
2011/03/08 07:30

as the format. I want to take out the date part of this, so it would just show 07:30.

Anyone know how to do this? Is it possible?

This message has been edited. Last edited by: Kerry,


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
March 07, 2011, 02:26 PM
JeffZ
START_PROJECTED/HHI or
START_PROJECTED/HHIA if you want 07:30AM

This message has been edited. Last edited by: JeffZ,


WebFocus 7.6.11
Windows
Sybase & SQL Server
March 07, 2011, 02:48 PM
Jason K.
Works Great!
Thanks!


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.