RE: [EXTERNAL] Re: Reporting by month value
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: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
actionsgenerating 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=E,1,6QZ0jKLa6I8uvX5ueEEhdne-O_4PVrZGWdHa3oaLLG10EuEmx9kYwFL_a2jkWGie6jYURTSqOx-gb9cI4C_G3bcC9OzCQS01BqxHaKO3vfnumQ4BZHt6fgbXxv4,=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=E,1,W23uwaNX63Rj9Qyxg9P8dR5V0SaVjnRs-_jYtTDLc80LNED_TeU9et54mSlDUdqfAPdIncfU4bcAUZDggzmmME4YPuCTaae4cnvjXCcV3iecE4-Z6PjwMQu2=1>
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
RE: [EXTERNAL] Re: Reporting by month value
Dustin,
If you have developer control over the form you can add some hidden
“housekeeping” fields.
I usually build a 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
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 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
actionsgenerating 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=E,1,6QZ0jKLa6I8uvX5ueEEhdne-O_4PVrZGWdHa3oaLLG10EuEmx9kYwFL_a2jkWGie6jYURTSqOx-gb9cI4C_G3bcC9OzCQS01BqxHaKO3vfnumQ4BZHt6fgbXxv4,=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=E,1,W23uwaNX63Rj9Qyxg9P8dR5V0SaVjnRs-_jYtTDLc80LNED_TeU9et54mSlDUdqfAPdIncfU4bcAUZDggzmmME4YPuCTaae4cnvjXCcV3iecE4-Z6PjwMQu2=1>
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
Re: [EXTERNAL] Re: Reporting by month value
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
> actionsgenerating 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=E,1,6QZ0jKLa6I8uvX5ueEEhdne-O_4PVrZGWdHa3oaLLG10EuEmx9kYwFL_a2jkWGie6jYURTSqOx-gb9cI4C_G3bcC9OzCQS01BqxHaKO3vfnumQ4BZHt6fgbXxv4,=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=E,1,W23uwaNX63Rj9Qyxg9P8dR5V0SaVjnRs-_jYtTDLc80LNED_TeU9et54mSlDUdqfAPdIncfU4bcAUZDggzmmME4YPuCTaae4cnvjXCcV3iecE4-Z6PjwMQu2=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
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
[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
actionsgenerating 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=E,1,6QZ0jKLa6I8uvX5ueEEhdne-O_4PVrZGWdHa3oaLLG10EuEmx9kYwFL_a2jkWGie6jYURTSqOx-gb9cI4C_G3bcC9OzCQS01BqxHaKO3vfnumQ4BZHt6fgbXxv4,=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=E,1,W23uwaNX63Rj9Qyxg9P8dR5V0SaVjnRs-_jYtTDLc80LNED_TeU9et54mSlDUdqfAPdIncfU4bcAUZDggzmmME4YPuCTaae4cnvjXCcV3iecE4-Z6PjwMQu2=1>
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
