take a look at the below code...

  
TABLE FILE B_SQL_PROJECTS
PRINT
COMPUTE DOCTYPE/A10='RFI';
     DATECREATED NOPRINT
COMPUTE CURDATE/YYMD='&YYMD'; NOPRINT
COMPUTE DATE1/YYMD=HDATE(DATECREATED,'YYMD'); NOPRINT
COMPUTE DATE2/I5 = DATEDIF(DATE1,CURDATE, 'D'); AS 'XYZ'
BY      NUMBER
-*WHERE NUMBER EQ 'T212091' OR 'T211871' OR 'T212173' OR 'T202590';
WHERE NUMBER EQ 'T212091' OR 'T212173';
ON TABLE SET PAGE-NUM OFF
ON TABLE HOLD AS HOLD1
END
-RUN
DEFINE FILE HOLD1
CATEGORY/A20= IF XYZ (GE 3 AND LE 5) THEN 'THREE' ELSE 
						IF XYZ (GT 5 AND LE 15) THEN 'FIVE' ELSE 
						IF XYZ (GT 15 AND LE 30) THEN 'FIFTEEN' ELSE 
						IF XYZ GT 30 THEN 'THIRTY' ELSE 'ONE';
END
TABLE FILE HOLD1
PRINT 
CATEGORY 
END
-RUN
-EXIT

It's giving error message "(FOC263) EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: XYZ"

No clue how to handle it...any help ?

tks/sam

XYZ in your code is presumed to be a function because of the way you have coded the define.

Place parenthesis in the right place.

hey got..thanks...

quote:

COMPUTE DATE2/I5 = DATEDIF(DATE1,CURDATE, 'D'); AS 'XYZ'

Not to mention your fieldname would be DATE2 unless you use ASNAMES.

the parenthessis in the define was the issue...hope this clarifies....