that query should work, agreed it is complicated by each year you want, but
it's the best I think you can do.
On Wed, Jan 31, 2018 at 2:23 PM, Fawver, Dustin <faw...@mail.etsu.edu>
wrote:
> 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 <(423)%20439-4648>
>
> itsh...@etsu.edu
>
> [image: 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>
> 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 <(423)%20439-4648>
>
> itsh...@etsu.edu
>
> [image: 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
> 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
>
>
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
