for the following code I got the error (FOC262) UNBALANCED PARENTHESES and these two lines utilizing in Focus Procedure

-SET &&HISTORICAL_MTH_END_DT= AYMD(&Contant_Value, -1, 'I8YYMD');

-SET &&HISTORICAL_MTH_END_DT_C = CAST(EDIT('&&HISTORICAL_MTH_END_DT','9999/99/99') AS DATE);

Any Clue ? for the missing parantheses

here is the Full Code for Focus Procedure

-SET &ECHO=ALL;

-SET &Contant_Value = '20150101';
-SET &&HISTORICAL_MTH_END_DT= AYMD(&Contant_Value, -1, 'I8YYMD');
-SET &&HISTORICAL_MTH_END_DT_C = CAST(EDIT('&&HISTORICAL_MTH_END_DT','9999/99/99') As DATE );
-TYPE &&HISTORICAL_MTH_END_DT
-RUN

This message has been edited. Last edited by: <Kathryn Henning>,

I'm not sure you can use DB expressions in Dialogue Manager. I would be inclined to use them in a DEFINE associated with a relational table. In any case, you might try using the DB_EXPR function:

DB_EXPR(CAST(EDIT('&&HISTORICAL_MTH_END_DT','9999/99/99') AS DATE));

The suggested proposal would not work

You are probably going to have to do it in 3 lines.

Also you probably need to have the final line in quotes otherwise Dialoge Manager will treat CAST and DATE as DM functions.

Try

-SET &&HISTORICAL_MTH_END_DT= AYMD(&Contant_Value, -1, 'I8YYMD');
-SET &&HISTORICAL_MTH_END_DT_A = EDIT('&&HISTORICAL_MTH_END_DT','9999/99/99');
-SET &&HISTORICAL_MTH_END_DT_C = 'CAST( &&HISTORICAL_MTH_END_DT_A AS DATE)';

You may need to change the thirdline to be

-SET &&HISTORICAL_MTH_END_DT_C = 'CAST( &&HISTORICAL_MTH_END_DT_A.EVAL AS DATE)';

OR

-SET &&HISTORICAL_MTH_END_DT_C = 'CAST( &&HISTORICAL_MTH_END_DT_A.QUOTEDSTRING AS DATE)';

depending on your SQL variant.

Cheers

Stu

What do these resolve to when they're expanded at runtime? Are there ever parens or quotes in the amper-variables that could gum up the works?