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...
Prod: WebFOCUS 7.6.10 MRE
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC
What 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?
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
I've not worked with that format, but in the master if it is a usage USAGE=HYYMDS, would HDATE work?
If you never use the time part of that date field you can also change the master.
Or add an extra field in the master witch points to the same field and with the settings mentioned above.
|Powered by Social Strata|