Deleting old cases
I want to delete old cases having case status resolved-cancelled and case id created older than 180 days. I am using obj browse to get case id but how can i retrieve cases created older than 180 days using pxcreatedatetime in obj browse method in activity. I need to this with activity itself
You can use 2 functions addToDate and getCurrentDateStamp to achieve this.
You can compare pxCreateDatetime with @addToDate(@getCurrentDateStamp(),-180,0,0,0) which gets cases older than 180 days. PFB screenshot for more details.