Reports display incorrect result


(29678 False)

 

Product

  
 Applies To 
  
 Product(s):eB
 Version(s):16.7.x, 16.X.X
 Environment: N/A
 Area: Reports
 Subarea: 
 Original Author:Padma Kanadi, Technical support engineer

Problem Description:

Incorrect results are displayed in the reports.

for example: If I select 07/10/19 I get results from 10/07/2019 instead of 07/10/2019.

 

Solution:

1.Set the date format to dd/mm/yyyy format in the windows Region settings.

2.On Region and Language, change the Format for date from English (UK) to English (your region where issue occurs).

This changed the date format, and you have to go into Additional settings  in order to be able to specify dd/mm/yyyy.

This will resolve the problem.

Note: check the Language, Decimal and Digital Grouping setting in Regional Settings.