I would appreciate any assiistance with isolating 'unbalanced parenthesis' in the code below. I have reviewed this code a couple of times and cannot pinpoint line causing unbalanced parenthesis error. I need a 'fresh' set of eyes:

-SET &TWOWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-14'),
-'YYMD','I8YYMD');
-SET &FOURWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-28'),
-'YYMD','I8YYMD');
-SET &SIXWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-42'),
-'YYMD','I8YYMD');
-SET &EIGHTWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-56'),
-'YYMD','I8YYMD');
-SET &TENWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-70'),
-'YYMD','I8YYMD');
-*-SET &TWOWKS= DATECVT(DATEADD(DATECVT(20080224,'I8YYMD','YYMD'),'D','-14'),
-*-'YYMD','I8YYMD');
-*-SET &FOURWKS= DATECVT(DATEADD(DATECVT(20080224,'I8YYMD','YYMD'),'D','-28'),
-*-'YYMD','I8YYMD');
-*-SET &SIXWKS= DATECVT(DATEADD(DATECVT(20080224,'I8YYMD','YYMD'),'D','-42'),
-*-'YYMD','I8YYMD');
-*-SET &EIGHTWKS= DATECVT(DATEADD(DATECVT(20080224,'I8YYMD','YYMD'),'D','-56'),
-*-'YYMD','I8YYMD');
-*-SET &TENWKS= DATECVT(DATEADD(DATECVT(20080224,'I8YYMD','YYMD'),'D','-70'),
-*-'YYMD','I8YYMD');
-*-EXIT

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

Try this way

SET &DAYS=DATECVT((DATEADD((DATECVT(&YYMD,'I8YYMD','YYMD')),'M', + 1 )-2),'YYMD','I8YYMD');

jjohnson,

I took your code and ran it in 713 and 764. Both ran ok, without any problem.

So I wonder if this is caused by something that might be present in your fex before this piece of code.

BTW: you should be able to have the statements on one line, like:

-SET &TWOWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-14'),'YYMD','I8YYMD');
  

I think your problem is due to the fact that the second line of the -SET statement needs a space between the - and the ':

  
-SET &TWOWKS= DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D','-14'),
- 'YYMD','I8YYMD');

I don't see any unballanced parens either. But the DATEADD call looks wrong, on two counts. You've got

... DATEADD( DATECVT(&YYMD,'I8YYMD','YYMD'), 'D', '-14' ) ...

With
arg1 = result of inner DATECVT
arg2 = 'D' for Days
arg3 = '-14' as number of days

But (according to the syntax reqirements quoted below),

a. arg3 should be numeric (rather than character); remove the quotes
b. arg4, the ouput format for DATEADD, is needed (s/b 'YYMD', matching the trailing arg of the inner DATECVT call, snce that is DATEADD's input)

-- as sometimes happens, the parser caught an error, but triggered the wrong error-message number.

Syntax: How to Add or Subtract a Date Unit to or From a Date 

DATEADD(date, 'unit', #units, outfield)
 where: 

 date   Date           Is a full component date.

 unit   Alphanumeric   Is one of the following enclosed in single quotation marks:

  Y indicates a year unit.
  M indicates a month unit.
  D indicates a day unit.
  WD indicates a weekday unit. 
  BD indicates a business day unit. 

 #units   Integer      Is the number of date units added to or subtracted from date. If this number is not a whole unit, it is rounded down to the next largest integer.

 outfield   Date (numeric date offset)     Is the name of the field that contains the result, or the format of the output value enclosed in single quotation marks. 

Sorry for late response. I was out on vacation and turn this issue over to peer for resolution.

Thank you all for your help. I learned this has been resolved. Apprently, there was some bug and we had to download a patch for implementation, which corrected the issue with date fields.