datediff in documentum api

PrashantKoli

Hi all,

I want to archive objects which are processed 90 days before the current date. The following works well,

id,c,order where datediff(day,processed_date,date(today))>90

but if i use archive api

archive,c,order where datediff(day,processed_date,date(today))>90

what could be the problem

DCTM_Guru

Is "order" your object type?  Your query should be "object type where ..."  If so, this might be a reserved word.