Almost forgot. For backfilling old records replace the $DATE$ string with the $3$ value (usually $Create Date$ Run it with an escalation that sets MM to 13 and have the filter trigger on modify when MM=”13”. Then just fix the filter to run on submit with no runif qualification.
Thank you, --- John J. Reiser Building 760-J202 Remedy AR System Developer Senior Software Development Analyst Lockheed Martin - RMS Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: ARSList [mailto:[email protected]] On Behalf Of Fawver, Dustin Sent: Wednesday, January 31, 2018 4:23 PM To: ARSList <[email protected]> Subject: EXTERNAL: RE: [EXTERNAL] Re: Reporting by month value LJ, While that qualification is simple, it becomes complex for what I need. I could create one that works for a few years, such as: ('Requisition Date' >= "1/1/2018" AND 'Requisition Date' < "2/1/2018") OR ('Requisition Date' >= "1/1/2017" AND 'Requisition Date' < "2/1/2017") OR ('Requisition Date' >= "1/1/2016" AND 'Requisition Date' < "2/1/2016") OR ('Requisition Date' >= "1/1/2015" AND 'Requisition Date' < "2/1/2015") Do you think that’s the answer? If so, I suppose I could use that and just duplicate the report for each month of the year. Thanks! Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648 [email protected]<mailto:[email protected]> [itslogo]<http://www.etsu.edu/helpdesk> From: ARSList [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, January 31, 2018 4:11 PM To: ARSList <[email protected]<mailto:[email protected]>> Subject: [EXTERNAL] Re: Reporting by month value Dustin, If you are trying to do that in a Run-If or qualification, you can't use 'functions' in those areas...you can only use them in set/push actions....generating a report for everything in January would be something like 'Requisition Date' >= "1/1/2018" AND 'Requisition Date' < "2/1/2018" The reason 'LIKE' doesn't work is because the date is stored as either the number of seconds since Jan 1 1970 or the number of days since 'way back' (don't remember the actual date)....but you can only do like statements on strings, which it's not...so it needs to be mathematical in nature. On Wed, Jan 31, 2018 at 2:00 PM, Fawver, Dustin <[email protected]<mailto:[email protected]>> wrote: Greetings! I have a form that includes a date field. There are records with dates spanning several years. I need to generate a report that returns records that have a date value for a particular month of the year. For instance, I may need to find records that have a date that falls in January. I have tried the following qualifications to no avail. ‘Requisition Date’ LIKE “1/%” MONTH(‘Requisition Date’) = 1 MONTH($\Requisition Date$) = 1 DATENUM(“m”, $\Requisition Date$) = 1 It doesn’t like the month or datenum functions, and it flags the first qualification as having an invalid date value. I’m running this on ARS 9.1.02. Smart Reporting isn’t an option since I don’t have any ITSM licenses. Thanks! Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648<tel:(423)%20439-4648> [email protected]<mailto:[email protected]> [itslogo]<https://linkprotect.cudasvc.com/url?a=http://www.etsu.edu/helpdesk&c=E,1,6QZ0jKLa6I8uvX5ueEEhdne-O_4PVrZGWdHa3oaLLG10EuEmx9kYwFL_a2jkWGie6jYURTSqOx-gb9cI4C_G3bcC9OzCQS01BqxHaKO3vfnumQ4BZHt6fgbXxv4,&typo=1> -- ARSList mailing list [email protected]<mailto:[email protected]> https://mailman.rrr.se/cgi/listinfo/arslist<https://linkprotect.cudasvc.com/url?a=https://mailman.rrr.se/cgi/listinfo/arslist&c=E,1,W23uwaNX63Rj9Qyxg9P8dR5V0SaVjnRs-_jYtTDLc80LNED_TeU9et54mSlDUdqfAPdIncfU4bcAUZDggzmmME4YPuCTaae4cnvjXCcV3iecE4-Z6PjwMQu2&typo=1>
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
