Hi Joe, I will check this out when I get back on site tomorrow. Thanks. Nyall
Sent from Outlook _____________________________ From: Joe D'Souza <jdso...@shyle.net> Sent: Sunday, October 4, 2015 10:17 Subject: Re: Issue with date range for a report in ARS v8.1 To: <arslist@arslist.org> ** 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:arslist@ARSLIST.ORG] On Behalf Of Nyall McCavitt Sent: Friday, October 02, 2015 5:27 PM To: arslist@ARSLIST.ORG 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"