I have a database that I have developed for a small transport company. One of my portals shows runs that are pending waiting to be dispatched. I use a calc called IsEmpty=(Dispatch).It shows all runs that are pending no mater what date the run is assigned to. What I need is to only show runs for the current date not tommorow or next week just for todays date, Hope I haven't confused anyone. How can I do this?

Thanks in advance.

sounds like you need a relationshipe between creation_date and current_date

current_date would be a calculated fields with Get (CurrentDate)