Can anyone see why I might be getting this error?

SET NODATA = 0
SET HOLDLIST=PRINTONLY
SET ASNAMES=ON
SET SHOWBLANKS = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON
-RUN
-SET &EndDate = '02242011';
-SET &MSDYYMD = EDIT('02242011','$$$$9999') || '-' || EDIT('02242011','99$$$$$$') || '-01';
-SET &EDYYMD = EDIT('02242011','$$$$9999') || '-' || EDIT('02242011','99$$$$$$') || '-' || EDIT('02242011','$$99$$$$');
-SET &ENTYR = EDIT('02242011','$$$$9999');
-SET &ENTMT = EDIT('02242011','99$$$$$$');
0 ERROR AT OR NEAR LINE 18 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC295) A VALUE IS MISSING FOR: &M



Here is my code:

-SET &EndDate = '&MDYY';
-SET &MSDYYMD = EDIT('&EndDate.EVAL','$$$$9999') || '-' || EDIT('&EndDate.EVAL','99$$$$$$') || '-01';
-SET &EDYYMD = EDIT('&EndDate.EVAL','$$$$9999') || '-' || EDIT('&EndDate.EVAL','99$$$$$$') || '-' || EDIT('&EndDate.EVAL','$$99$$$$');
-SET &ENTYR = EDIT('&EndDate.EVAL','$$$$9999');
-SET &ENTMT = EDIT('&EndDate.EVAL','99$$$$$$');
-SET &ENTYRMT = '&ENTYR.EVAL' | '&ENTMT.EVAL';
-SET &FISCYR = IF '&ENTMT.EVAL' EQ '11' OR '12' THEN '&ENTYR.EVAL' ELSE ('&ENTYR.EVAL' - 1);
-SET &FISCSD = '&FISCYR.EVAL' | '-11-01';
-SET &FISCSM = EDIT('&FISCSD.EVAL','9999$$$$') | EDIT('&FISCSD.EVAL','$$$$99$$');
-SET &PENTYR = &ENTYR - 1;
-SET &PEDYYMD = '&PENTYR.EVAL' | '-' | '&ENTMT.EVAL' | '-' | EDIT('&EndDate.EVAL','$$99$$$$');
-SET &PMSDYYMD = '&PENTYR.EVAL' | '-' | '&ENTMT.EVAL' | '-01';
-SET &PFISCYR = &FISCYR - 1;
-SET &PFISCSD = '&PFISCYR.EVAL' | '-11-01';
-SET &PFISCSM = EDIT('&PFISCSD.EVAL','9999$$$$') | EDIT('&PFISCSD.EVAL','$$$$99$$');
-SET &PENTYRMT = '&PENTYR.EVAL' | '&ENTMT.EVAL';
-RUN  

I use this same logic in other procedures and it works, but I'm allowing the user to enter the date for those.

Thanks for your help.

This message has been edited. Last edited by: jseaburn,

Because the variable &EndDate has the string &MDYY in it. So &ENTMT has the string &M.
Suggest you do

-SET &EndDate = '&MDYY.EVAL';

or

-SET &EndDate = &MDYY;

WOW! Rookie mistake. That did it! Thank you so much!