2 Replies Latest reply: Feb 5, 2013 10:02 AM by dbuijsman RSS

    Problem with showing values without the status 'End'

      Hi,

       

      Im making an applications with different tables with many data. Lets look at his example what causes the trouble (This is just an example, with dummy data to make the problem clear):

       

      IDSTATUSBegin dateEnd date
      1Start1-1-20014-1-2001
      1Middle4-1-20018-1-2001
      1almost finished 8-1-200118-1-2001
      1End18-1-200123-1-2001
      2Start1-1-20013-1-2001
      2Middle3-1-20018-1-2001
      2almost finished 8-1-200118-1-2001
      2End18-1-200121-1-2001
      3Start1-2-20014-2-2001
      3Middle4-2-20018-2-2001
      3almost finished 8-2-200118-2-2001

       

      What i want is to show the ID's that not have ended, with the amount of days from the start. So today() - Begin date where the ID dont have an End status. If i do a not wildmatch on the word 'End' it still shows the ID cause of the same ID numbers with another status.

       

      Does somebody know an solution for this?

       

       

      *Im using the personal edition, so i can't open QVW files from others.