I have an application with a Summary Grouped by a Date field.
The application grabs sales data from a database and presents the information on the Summary Grid.
The problem is tha when i use a Date Filter like ‘2019/06/01’ in the grid the information of amounts and units is ok but the Date value is always one day less than the one i filter.
I check the SQL statement and the where clause is build correctly, the problem is that when Scriptcase builds the Table with the information de date is wrong.
This issue only happends on the production environment, in Dev environment works ok.
I have already check TimeZone Information in PHP.ini and Production Environment Configuration and it is the same as Client and Server computer.
Does anyone had this problem in the past and can help me?
Thank you very much in advance.