How to query in eScript for old records
bcAccount.SetSearchExpr("[Type] <> 'Residential' AND [Created] < (Today()-daysvar)");
where daysvar can have any value.
Getting below error :
---------------------------
Siebel
---------------------------
[1] The query expression on field 'Created' is not valid. Please revise and try again.(SBL-DAT-00399)
[2] CSSUtcDateTime doesn't support operator '<' with 'CSSInteger'(SBL-DAT-00480)
---------------------------
OK
---------------------------
How to solve this ?
[19-Dec-2014]: I can query successfully when i use Today()-100 i.e. by hardcoding. 'Created' is a system field, not required to be exposed on UI for my requirement. My requirement is simply to query for Account records which are more than a year or 'daysvar' no.of days(configurable).