Focal Point
[SOLUTION] Date-Time column displayed as Year/Month/Day Hour:Minute - No Second?

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

July 14, 2008, 11:36 AM
Francis Mariani
[SOLUTION] Date-Time column displayed as Year/Month/Day Hour:Minute - No Second?
I'd like to display a Date-Time column as Year/Month/Day Hour:Minute - No Second, e.g. 2008/07/02 14:58.

What format would I use for this?

HYYMDS gives me 2008/07/02 14:58:00
HYYMDIa gives me 2008/07/02 02:58pm
HHIa gives me 02:58pm

Thanks,

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 14, 2008, 11:50 AM
jimster06
HYYMDI comes to mind.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
July 14, 2008, 11:54 AM
Francis Mariani
jimster06,

Thanks! That did the trick.

Cheers,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server