11 Replies Latest reply: Nov 26, 2014 12:55 AM by anbu cheliyan RSS

    Database contains: FromDate, ToDate: Show correct values for month in between?

      Hello everyone,

       

      I need help showing the correct data from database.

      The structure of the database is as following:

      ID     FromDate     ToDate               Costs

      1     10.02.2014     30.06.2014         500€

       

      The problem is:

      How can I show the correct data when I want to see the cumulated values for May in example 1?

      As QV does not recognize there are any data in there. The correct costs for that month should be 500€ / 140 * 31 = 110,71€.

       

       

      Thanks in advance!