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

Reply via email to