I have the below expression in an expression query.. but want to query for days not months... thoughts on how to tweak this for days?
(( PERMITSTATUS LIKE 'COMPLETED'
OR PERMITSTATUS LIKE 'CANCELED'
OR PERMITSTATUS LIKE 'DENIED'
OR PERMITSTATUS LIKE 'Maintenance')
AND
PERMITCHANGEDATE >= ADD_MONTHS(TO_DATE(SYSDATE),-3))
