Command Console:
---------------------------

-SET &YEARMONTH = '200905';
-SET &YEAR = '2009';

DEFINE FILE DATE
ACDT1/I8YYMD=DATECVT(DATE,'YYMD','I8YYMD');
ACDT2/A8=EDIT(ACDT1,'99999999');
ACDT3/A6=EDIT(ACDT2,'999999$$');
END
TABLE FILE DATE
PRINT
DST.DATE
ACDT3
ACDT2
COMPUTE DT1/YYMD=DATEADD(DATE,'M',-2); AS DT11
COMPUTE DT2/YYMD=DATEMOV(DT1,'EOM'); AS DT22
COMPUTE DT3/A8=DATECVT(DT2,'YYMD','A8'); AS DT33
WHERE YEAR EQ '&YEAR';
WHERE ACDT2 LIKE '%01';
WHERE ACDT3 IN (&YEARMONTH);
END



No HTML Output!

--------------------------------------------------------------------------------


0 ERROR AT OR NEAR LINE 19 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

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

Hi,

You might be missing quote on the variable &YEARMONTH

 WHERE ACDT3 IN ('&YEARMONTH'); 

See if that helps.

Best Regards,

Jimmy Pang

WHERE ACDT3 EQ '&YEARMONTH';

But there's a few things wrong with this code.

Also whats the format of the YEAR column, is it Alpha or numeric ?

quote:

Originally posted by fatboyjim:
Hi,

You might be missing quote on the variable &YEARMONTH

 WHERE ACDT3 IN ('&YEARMONTH'); 

See if that helps.

Best Regards,

Jimmy Pang

It sure did help.

Thanks,