The input field is 2009/11/17 15:53:51.385000 in the format of HYYMDM. I need to convert into only 11/17/2009. Is there any short cut for this conversion. thanks for the help ramaThis message has been edited. Last edited by: Kerry,
WebFOCUS 762 Windows To be decided(All formats)
March 08, 2010, 02:02 PM
Ram Prasad E
Rama,
Search for HDATE, this function will solve your problem.
Hi Ram Thanks for your very nice hint.It worked. thanks, rama
WebFOCUS 762 Windows To be decided(All formats)
March 08, 2010, 02:14 PM
Francis Mariani
DEFINE FILE CAR
DATE1/HYYMDm = HINPUT(26, '2009/11/17 15:53:51.385000', 10, 'HYYMDm');
END
TABLE FILE CAR
PRINT
COUNTRY
DATE1
DATE1/HYYMDS
DATE1/HYYMD
DATE1/HYY
END
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
March 08, 2010, 02:47 PM
ramakrk
Francis, This is very nice. thanks for the help, rama