0 Replies Latest reply: Dec 2, 2014 7:00 AM by Jesús Pau RSS

    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.