AnsweredAssumed Answered

Calculation to find overdue call back date and time

Question asked by jakes on Sep 23, 2014
Latest reply on Sep 23, 2014 by philmodjunk

Title

Calculation to find overdue call back date and time

Post

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?

 

Outcomes