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 <http://aka.ms/Ox5hz3> 


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to