You can use an inner query on the openactivities .You can order by DESC for this and also filter by activity date > today()
Mohith Shrivastava
- 92k
- 19
- 161
- 214