Return dates older than a specific date

[nicolai_moller]

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?

[Kushal_Chawda · Accepted solution]

Please see the attached file.