I simply cannot chase down the error in this &ECHO. Can anyone lend an eye ?

quote:

ERROR AT OR NEAR LINE 16 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC262) UNBALANCED PARENTHESES
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

 -DEFAULT &DATE1 = '20180301';


 TABLE FILE WF_RETAIL
 SUM
 WF_RETAIL.WF_RETAIL_SALES.COGS_US
 WF_RETAIL.WF_RETAIL_SALES.QUANTITY_SOLD
 WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
 BY  LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
 BY  LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
 BY  LOWEST WF_RETAIL.WF_RETAIL_PRODUCT.MODEL
 BY  LOWEST WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT
 IF RECORDLIMIT EQ 25

 WHERE ( WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ 'Accessories' );
 WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING );

 ON TABLE SET PAGE-NUM NOLEAD
 ON TABLE SET ASNAMES ON
 ON TABLE NOTOTAL
 ON TABLE PCHOLD FORMAT HTML
 ON TABLE SET HTMLEMBEDIMG ON
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *

 -INCLUDE _EDAHOME/ETC/warm.sty
 $ Copyright 1996-2015 Information Builders, Inc. All rights reserved.
 -*  $Revision: 1.32 $
 *TABLE_STYLE
 TYPE=REPORT,
 GRID=OFF,
 FONT='IBIDefault',
 SIZE=9,
 STYLE=NORMAL,
 SQUEEZE=ON,
 COLOR=RGB(20 20 20),
 PAGECOLOR='WHITE',
 BORDER-COLOR=RGB(219 219 219),
 TITLELINE=SKIP,
 HYPERLINK-COLOR=RGB(51 102 255),
 $
 TYPE=REPORT,GRAPHCOLOR='SILVER',GRAPHCOLORNEG='RED',GRAPHWIDTH=.18,$
 TYPE=REPORT,
 OBJECT=MENU,
 SIZE=9,

. . . . . . . .

This message has been edited. Last edited by: FP Mod Chuck,

Add ) at the end...

  
WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING ));

Quote:

WHERE ( WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ 20180301.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING );

Please post the raw code for this line. &ECHO=ON should show a resolved value in place of each referenced &var, so

.(|FORMAT=YYMD).Sale,Date:.QUOTEDSTRING"

should have been swallowed along with the name of the &var.