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 [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> 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