Dustin, If you have developer control over the form you can add some hidden “housekeeping” fields. I usually build a YYYY field and a MM field on each form that will get reports generated. Use functions in filters on submit to fill the fields. Set fields action YYYY YEAR($DATE$) MM (LPAD(MONTH($DATE$),2,”00”)
Then you can search for MM = “01” to get all of the January records regardless of the year. You can use the YYYY to group report data by year if you’d like. 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:arslist-boun...@arslist.org] On Behalf Of Fawver, Dustin Sent: Wednesday, January 31, 2018 4:23 PM To: ARSList <arslist@arslist.org> 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 itsh...@etsu.edu<mailto:itsh...@etsu.edu> [itslogo]<http://www.etsu.edu/helpdesk> From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Wednesday, January 31, 2018 4:11 PM To: ARSList <arslist@arslist.org<mailto:arslist@arslist.org>> 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 <faw...@mail.etsu.edu<mailto:faw...@mail.etsu.edu>> 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> itsh...@etsu.edu<mailto:itsh...@etsu.edu> [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 ARSList@arslist.org<mailto:ARSList@arslist.org> 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 ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
