The title might be a litle confusing, but I dont know how to explain it better. Here is my problem: I have three lists - LIST1, LIST2, LIST3.
LIST1 and LIST2 are not interesting. LSIT3 contains all the records from LIST1 and LIST2 and some other records. LIST3 should show all the records that are not updated within the last 5 days. LIST3 should also take in consideration, when some record is updated in LIST1 or LIST2 the last 5 days, it should not be displayed.
In other words LIST3 should show all records that: - are not modified the last 5 days in LIST3 AND are not modified the last 5 days in LIST2 AND are not modified the last 5 days in LIST1