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:54 AM
Francis Marianijimster06,
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