3 Replies Latest reply on Sep 23, 2014 12:03 PM by philmodjunk

    Calculation to find overdue call back date and time

    jakes

      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?