Calculation to find overdue call back date and time
I have 2 fields 1)Call Back Date (Date field) 2) Call Back Time (Time field)
Is there a way to calculate how many records are over due a call back based on the current date for the full database.
This calculation seems to work but for only one record.
GetAsTimestamp ( callback_date &" " & call_back_time ) - Get ( CurrentTimeStamp ) < 0
Is there a better way of calculating this?