January 23, 2007, 12:02 PM
tlbrydie2Date time conversion
I have a date format '2007-01-17 00:00' that I am trying to convert for a report. Does anyone know of a function that would work or the format I could use with the edit function. I've tryed HPART and HCNVRT with no luck...
Any suggestions
January 23, 2007, 12:15 PM
Francis MarianiWhat is the data format of the field, alpha or DATE or HYYMDS? There are no seconds or milliseconds?
What are you trying to convert it to?
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
January 23, 2007, 12:30 PM
LeahI've not worked with that format, but in the master if it is a usage USAGE=HYYMDS, would HDATE work?
January 23, 2007, 02:10 PM
FrankDutchIf you never use the time part of that date field you can also change the master.
USAGE=YYMD, Actual=DATE.
Or add an extra field in the master witch points to the same field and with the settings mentioned above.