I AM TRYING TO GET NO OF DAYS BETWEEN TWO DATES USING THE DATEDIFF FUNCTION. I AM GETTING THE NO REFERENCE FIELD DATA ERROR. ANY BODY PLEASE SUGGEST ME.
THIS IS THE EXAMPLE -SET &START_DATE = '2008/05/01'; -SET &END_DATE = '2008/07/31'; DEFINE FILE EMPDATA DATED/I8 = DATEDIF('&END_DATE', '&START_DATE','D'); END TABLE FILE EMPDATA PRINT DATED END -EXIT
WEBFOCUS 7.6.4,WINDOWS XP,ORACLEThis message has been edited. Last edited by: Kerry,
October 21, 2008, 10:14 AM
TexasStingray
just add another field to the table request with noprint or change it to use dialog manager instead of the define and table request.
TABLE FILE EMPDATA
PRINT
DATED
EMPID NOPRINT
END
or
-SET &DATED = DATEDIF(&END_DATE, &START_DATE, 'D');
-TYPE &DATED
Hope this helps
Scott
October 22, 2008, 05:35 PM
Waz
To be even safer, add a WITH {Field Name} to the define. The db field in the TABLE FILE is then optional. The WITH command links the define file to "Real" data.
-SET &START_DATE = '2008/05/01';
-SET &END_DATE = '2008/07/31';
DEFINE FILE EMPDATA
DATED/I8 WITH PIN = DATEDIF('&END_DATE', '&START_DATE','D');
END
TABLE FILE EMPDATA
PRINT
DATED
END
-EXIT