Hi Joe,
I will check this out when I get back on site tomorrow.
Thanks.
Nyall
Sent from Outlook
_____________________________
From: Joe D'Souza <[email protected]>
Sent: Sunday, October 4, 2015 10:17
Subject: Re: Issue with date range for a report in ARS v8.1
To: <[email protected]>
**
Have you logged SQL to see the query that is sent to the backend?
I am wondering if it does not like military style date formats.
Joe
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Nyall McCavitt
Sent: Friday, October 02, 2015 5:27 PM
To: [email protected]
Subject: Issue with date range for a report in ARS v8.1
**
Hi,
Just come across an interesting issue with reporting on ARS v8.1.
Date format is European i.e. DD/MM/YYYY in the following examples:
1. Start Date: 01/10/2015 08:00 End Date: 01/10/2015 18:30
This report returns zero entries even though there are tickets that match the
criteria. In this case the base qualification is 'Owner Group' LIKE 'Fr%' on
the HPD:Help Desk form. The form types is AR System.
2. Start Date: 01/10/2015 00:00 End Date: 02/10/2015 00:00
This report works as expected and returns a valid output.
Have had a quick look through BMC Knowledge and BMC Communities but haven't
found anything useful yet.
Has anyone esle come across this issue?
Thanks.
Nyall McCavitt
Sent from Outlook _ARSlist: "Where the Answers Are" and have been
for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
