how is it used?
Heading
"Submissions 1/1/ NEWYEAR Through &SDATEM &SDATEY"
USED THE ABOVE SYNTEX AND GOT
quote:
YY = SDATEY - 2;
FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: SDATEY
DEFINE FILE CAR
NEWYEAR/YY = SDATEY - 2;
END
TABLE FILE CAR
PRINT MODEL NEWYEAR
END
-RUN
No good.
0 ERROR AT OR NEAR LINE 3 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: SDATEY
0 ERROR AT OR NEAR LINE 7 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: NEWYEAR
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
May 12, 2006, 03:37 PM
Spencetry this.
-SET &CY = EDIT(&DATEYYMD,'9999$$$$');
-SET &PY = &CY - 2;
May 12, 2006, 03:42 PM
PrarieI thought your Date was already just a year...their examples should help.