DateTime Format Issue

[HighAley]

Hello.

Sorry for the issue.
We are still working on it.
We will let you know when we get any result.

Thank you.

Ticket reference: #3464.

[HighAley]

Hello.

We have made an improvement and checked the issue twice.
Now it is solved. we are very sorry.
Please, check the js.stimulsoft.com and download the official release once again.

Thank you.

[BCS]

At first glance it seems to be fixed, I will know more tomorrow I was tied up with other issues today.

[HighAley]

Hello.

Let us know if you need our help.

Thank you.

[BCS]

Everything seems to be fixed, only issue I'm having now is that the reports are not showing the correct time, its assuming UTC and subtracting 6 hours (-0600 Time Zone Central Time USA). In otherwords if the database value is 08:00 AM its displaying 02:00 AM. Do I need to set something in my JS code for this? The server is set to the correct timezone (PHP & MySQL).

I am using the text format for the reporting fields set to Custom with "MM/dd/yyyy hh:mm tt"

This is Stimulsoft Reports.JS 2016.3 Official Release

[HighAley]

Hello.

Could you specify what time is stored in your data source?
Could you send us a small sample that will show the issue?

Thank you.

[BCS]

DB Value: 2016-12-16 12:10:32
JSON Return: "2016-12-16 12:10:32"

MySQL Workbench shows: 2016-12-16 12:10:32
Cloudways online DB tool shows: 2016-12-16 12:10:32

All of these are in the correct timezone, even SQL dumps show 2016-12-16 12:10:32.

I am using Laravel as my framework if that helps and report views has your reporting tool integrated via javascript and ajax to fill the data onto the report. These values are all stored in local time.

[HighAley]

Hello.

We have reproduced the issue.
We need some time to fix it.

Thank you.

Ticket reference: #3557

[BCS]

Okie dokie, is there a workaround that could be employed at this time until a hotfix is available?

[HighAley]

Hello.

Yes, please, try to use different Text Format or ToString() method with custom format.

Thank you.