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

try this,

DEFINE FILE GGSALES
DT/YY=DATE;
DT1/YY=DT - 2;
END

TABLE FILE GGSALES
PRINT DATE DT DT1
WHERE RECORDLIMIT EQ 5
END
-EXIT

try this.

-SET &CY = EDIT(&DATEYYMD,'9999$$$$');
-SET &PY = &CY - 2;

I thought your Date was already just a year...their examples should help.