I am looking to create time based stored queries which will be used for aging i.e. requests > 30 days old (from open date) , requests between 31 days and 60 days old, etc. I have attempted to create a few but am receiving errors. Please assist. Thanks in advance.
Here is what I have so far: type \'R\' AND open_date > StartAtTime (\'TODAY\') + 30