How can we use sysdate in power filter. I want to fetch a list with condition like datefield<=sysdate+90
Is it possible with ca ppm?
You maybe able to use dateMacro like as below.
I don't have any document about dateMacro.
It seems not to be documented. I don't know whether it is supported function or not.
You cannot use database functions in the powerfilter, however you can use the date field and in your NSQL you can add +90 and show the data.
Some other datemacro options ; PowerFilter - dateMacro
Retrieving data ...