This content has been marked as final. Show 7 replies
Not as pretty, but this seems to work in the layout
<= (today()- 60)
this filter says is that the policy expiration date
must be less than (before) or equal to 60 days ago.
I tried to use that in the Layout filter and still get
the error "There are problems with this filter. Please
make any necessary corrections and check it again."
I'm guessing that it does not like the today().<br
If I do the filter not using the
"Advanced Filter..." option and set it for
"Expiration" "Less than <" "Sep 30, 2008" and
then change it to the Advanced Filter option I get
I try just modifying this, but have
had no luck which leads me to believe that the system
just can't handle today() in the filter. <br
What is the database engine you are running on (MS
SQL, Sybase, Oracle)?
enter in to the Advanced Filter option, you are
basically entering a SQL statement against the
database, so the syntax you use is specific to that
engine. For example, if using Sybase you can use a
filter of days ( policy_expires, CURRENT TIMESTAMP )
function and CURRENT TIMESTAMP functions / expressions
will vary if using MS SQL or Oracle.
In our case we are using Sybase.
We are using Oracle 9i. Any ideas what the appropriate
filter would be for an oracle platform?
Although I don't have a way to test this, I believe in
Oracle you can use: SYSDATE - policy_expires >=
Brilliant! That worked. Thanks for the help.