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:
Table 2:
| Other dates | Status |
|---|
| 2014-03-03 | completed |
| 2014-09-09 | completed |
| 2014-10-10 | waiting |
| 2014-11-11 | waiting |
Any suggestions?
