Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created a field (table 1) that gives me the the latest completed date that is <= today from table 2. Table 1 actually contains many dates, but there is only one possible value for each customer.
I want to return all dates from table 2 that are greater than the possible value in table 1, so in this case it should be 2014-10-10 and 2014-11-11.
Table 1:
Date |
---|
2014-09-09 |
Table 2:
Other dates | Status |
---|---|
2014-03-03 | completed |
2014-09-09 | completed |
2014-10-10 | waiting |
2014-11-11 | waiting |
Any suggestions?
Please see the attached file.
Please see the attached file.