posted August 18, 2016 11:24 AM
I tried using HDate to get my DateTime to only MDYY and then used the EDIT function to manipulate the date to MM/YYYY with no success.
Any further guidance is greatly appreciated.
This message has been edited. Last edited by: <Emily McAllister>, September 06, 2016 10:38 AM
posted August 18, 2016 11:32 AM
Look at the datetime functions in
In particular you might want to consider HDATE and then pop the result in a field with MYY format.
In FOCUS since 1986 WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2 WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: | Location: 5604 United Kingdom | Registered: April 08, 2004
posted August 19, 2016 12:50 PM
You could still use EDIT, but you'll have to use it twice: Once to convert from numeric to alpha and then again with a mask to extract the date.
WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
Posts: | Location: 674 Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010
posted August 22, 2016 08:46 AM
If this is a field a sql database, try adding a row to the master that defines the field as a date instead of a datetime field. I do it all the time.
FIELD=AS_BEGDTTM , STRT_DT , HYYMDS, HYYMDS ,$
FIELD=AS_BEGDT , STRT_DT , YYMD , DATE ,$
then print AS_BEGDT like this:
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
Posts: | Location: 923 Oklahoma City | Registered: October 27, 2006