However, when we try to use these parameters in our filters, it does not convert the parameter to the actual value. We receive an invalid date format error message.This message has been edited. Last edited by: <Kathryn Henning>,
Prod/Dev: WebFOCUS 8.0.08 on Windows Server 2008/Tomcat , WebFOCUS DevStudio 8.0.08 on Windows 7 Pro
April 09, 2013, 03:47 PM
<Kathryn Henning>
Hi Joey,
Are there -DEFAULT values for every &var contained within the Other section of the Reporting Object? If so, what is the exact error that you're receiving?
INVALID DATE FORMAT message indicates that you are trying to compare perhaps an Oracle Date which has a format that looks like your &TODAY.. variables, but isn't really. If your filter statement is IF SOMEDATE EQ &TODAY_START.QUOTEDSTRING then you are comparing some date format to an alphabetic charcter string. that's going to give you an INVALID DATE FORMAT message, b/c the alpha string is not a date, really. IF i'm right in my thinking about what you're doing, then first DEFINE a new date field in your Reporting Object, DEFINE FILE thing mydate/YYMD = HDATE( somedate, 'YYMD'); END and then do your filter IF mydate EQ &YYMD and that should work
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID