This content has been marked as final. Show 7 replies
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.