Year Format Year Format bsneln (MIS) (OP) 26 Jul 04 16:01 We have a field with a MDYY format. We need to be able to select just the year for the report to run. When we select the year, the report will display showing the MDYY formatted in another column. How do we do this? RE: Year Format Tewy (Programmer) 28 Jul 04 04:36 Are you computing the YEAR off the date rather than defining? When you use compute the report automatically includes the field used in the compute in the report. If this is what's causing the problem there are two options:1. Move your compute into a define2. Add the field yourself into the report with the NOPRINT command after it.If you are not using a compute, provide a few more details of where and how you are extracting the year for me.Tewy RE: Year Format bsneln (MIS) (OP) 28 Jul 04 10:10 To initiate this report, we will have the user select the "Year" for the report. Then we want the report to display:Title: Year To Date Summary Headings: PAY PERIOD example - 02/15/2000REGULAR OVERTIME ANNUAL SICK SICK FAMILY STATECOMP FED COMP HOLIDAYCOMP HOLIDAY OTHER Here is the first part of the code:-* File YTDSum.fexDEFINE FILE TIMESHEETSYEAR/YY=YEAR( TIMESHEETS.TIMEDATE );ENDTABLE FILE TIMESHEETSPRINT 'TIMESHEETS.REGULAR' 'TIMESHEETS.OVERTIME' 'TIMESHEETS.ANNUAL' 'TIMESHEETS.SICK' 'TIMESHEETS.SICKFAM' AS 'SICK,FAMILY' 'TIMESHEETS.COMP' AS 'STATE,COMP' 'TIMESHEETS.FEDCOMP' AS 'FED,COMP' 'TIMESHEETS.HOLCOMP' AS 'HOLIDAY,COMP' 'TIMESHEETS.HOLIDAY' 'TIMESHEETS.OTHER'BY 'TIMESHEETS.USERID' NOPRINTBY 'TIMESHEETS.TIMEDATE' AS 'PAY,PERIOD'BY 'TIMESHEETS.TIMEDATE' NOPRINT AS 'YEAR'HEADING"Year To Date Summary"" "" "" "FOOTING"Prepared on <+0>&DATEtMDYY <+0> "WHERE ( USERID EQ '&USERID.UserID.' );ON TABLE SET PAGE-NUM OFFON TABLE ROW-TOTAL AS 'TOTAL'ON TABLE COLUMN-TOTAL AS 'YTD'ON TABLE SET ONLINE-FMT HTMLON TABLE SET WEBVIEWER ONON TABLE SET HTMLCSS ONON TABLE SET STYLE *When run, we get the error message of Error:(FOC263) EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: YEAROur version says its 524. We tried to use a maintain specific legacy date function above (YEAR), but it didn't work. Any ideas?bsneln RE: Year Format focwizard (Vendor) 28 Jul 04 15:38 Replace your DEFINE with:DEFINE FILE TIMESHEETSYEAR/YY=TIMESHEETS.TIMEDATE ;ENDSetting a DATE format field to a date containing only the year in the format will do the conversion automatically. RE: Year Format bsneln (MIS) (OP) 28 Jul 04 17:16 Okay. I did that. We get the following error message:(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: DEFINEThanks for your help!bsneln RE: Year Format WFGuru (Vendor) 29 Jul 04 16:11 Sounds like there's something before your DEFINE that doesn't belong there. RE: Year Format focwizard (Vendor) 11 Aug 04 13:47 Did you remember to remove the original DEFINE FILE TIMESHEETS? RE: Year Format bsneln (MIS) (OP) 11 Aug 04 14:41 Got the procedure to work now by defining a new field as the YY format and are no longer receiving the error message. Thanks!!