Can someone please help me out - I cannot see where this code has unbalanced parentheis! This code that I am trying to run in WebFOCUS 7.7.03 on an AIX box.
SET YRTHRESH = 51
-RUN
-SET &ECHO=ALL;
-* GET THE CURRENT SYSTEM DATE IN YYMMDD FORMAT
-SET &CURR_DATE = &YYMD;
-* SUBTRACT ONE MONTH FROM TODAY'S DATE
-SET &DTE_PREV=DATECVT((DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'M',-1))'YYMD', 'I8YYMD');
-* ADD ONE MONTH TO TODAY'S DATE
-SET &DTE_NEXT=DATECVT((DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'M',+1))'YYMD', 'I8YYMD');

Thanks in advance,
Rhonda

DATECVT((DATEADD((DATECVT(&YYMD, I8YYMD, YYMD)), M, +1)), YYMD, I8YYMD);

Too quick, wow.

Thank you for the quick response! So fast!

Rhonda

quote:

DATECVT((DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'M',+1))'YYMD', 'I8YYMD');

You're using more parenthesis than you need, obscuring the issue. Next to that, you're missing a comma before the second 'YYMD':

DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'M',+1), 'YYMD', 'I8YYMD');
       ^                                             ^^^

Thanks again! The original code came from a solution I found in the IBI knowledge database. It needs to be corrected. Both solutions worked.

Best regards,
Rhonda