You could do $TIMESTAMP$ - 2629743 to get all records for roughly the last month. This doesn't take into account the fluctuation in days between months though.
On Wed, Aug 12, 2015, 10:54 AM Arner, Todd <[email protected]> wrote: > ** > > I am trying to schedule a web report to run monthly that will pull in all > records that were created in the previous month and not sure how to format > the query. Is there a way to set up a query in Remedy that will pull all > the records created in the previous month? I appreciate any help you can > provide. > > > > ARS 8.1 > > ITSM 8.1 > > MS SQL 2008 R3 > > > > Thanks, > > Todd > ------------------------------ > The information contained in this communication may be confidential, is > intended only for the use of the recipient(s) named above, and may be > protected under state or federal law. If the reader of this message is not > the intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this communication, or any of its contents, is > strictly prohibited. If you have received this communication in error, > please forward the communication to [email protected] immediately and > destroy or delete the original message and any copy of it from your > computer system. If you have any questions concerning this message, please > contact the sender. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
