I have a Table that holds comments made to a request table. Meaning One request can have multiple comments. Each request is connected to a Organization table as well. Same setup each Org can have Multiple Requests. In the request file I have a expire date. Now what I want to do is count all the comments for that orgs request that are not expired yet.
I have the count of all comments for that Org done.
Its when I try to filter the comments to exclude the comments that the request expire date has Passed.
I am not sure why it is not working.