Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Problems with custom calendar (or so I think)

Hi, community!

I've created a custom calendar for my application but something unexpected happens.

Context:

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.

Problem:

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!

Jesús.

Community Browser