I've created a custom calendar for my application but something unexpected happens.
There are two .QVW in my application,
Application 1 : which connects to SQL Server Database and generates QVD files.
Application 2 : which obtains data to QVD files and generates a Custom Calendar.
DATE is a custom calendar field that it has the date.
The datasource is a SQL Server Database, so when the application1 accesses the database before 11:AM, the function Max(DATE) = Today -1, but the access is after 11:AM, Max(DATE) = Today.
Does anyone know what happens?
I begin to believe that is a problem in timezone in application or database server. I hope you can help me!
Thank you very much!