BobVThis message has been edited. Last edited by: FP Mod Chuck,
WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8
January 23, 2019, 04:22 PM
Waz
Whats the field format ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 24, 2019, 03:36 PM
Doug
Is thisw a DB Field? Or, a Amper Variable (Dialogur Manager)?
January 25, 2019, 05:37 AM
Addy
Have a look at DATETRAN
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
January 25, 2019, 06:20 AM
Ian Dalton
Try this......
WMY/MtY = DATEXXXX;
where DATEXXXX is a smart date.
_______________________ *** WebFOCUS 8.1.05M ***
January 25, 2019, 12:43 PM
Hallway
TABLE FILE IBISAMP/EMPLOYEE
PRINT
COMPUTE HIRE_MDYY/MDYY = DATECVT(HIRE_DATE, 'I6YMD', 'MDYY') ;
COMPUTE HIRE_M-D/A6 = DATETRAN(HIRE_MDYY, '(MD)', '(t-)', 'EN', 6, 'A6');
BY LAST_NAME
BY FIRST_NAME
BY HIRE_DATE
WHERE DEPARTMENT EQ 'PRODUCTION';
ON TABLE SET PAGE-NUM OFF
END