Hi,I need to calculate the time between 2 timestampsTime between: Lead Created and Call Attempt 1 Call Attempt 1 to Call Attempt 2 Call Attempt 2 to Call Attempt 3 What is the best type of report to do this?What is the correct formula (assuming I need to add a formula)?I think it may be similar to this thread, but I want to calculate days instead of hours...https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=31861&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewerIf([Time Out] > [Time In],[Time Out] - [Time In],Hours(24) - ([Time In] - [Time Out]))Thanks,Matt------------------------------Mathew Crist------------------------------

Can you give a couple of example of the data you have and the result that you want?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Hi Mark,I'm trying to take account of how long we take to call someone from the time a lead comes in (Date created to Call Attempt 1). Beyond that, I would also like to determine how long it has been since the last attempt.Knowing this will give us more visibility as to:1) how long we generally take to reach out to our leads2) When it's time to try again (i.e. Call attempt 1 was 72 hours ago = time to try again).Thanks!Matt------------------------------Mathew Crist------------------------------

Can you give me an example of a single record (say the first one on that list if you like) and the correct calculated result.If you just want to know the number of days, then it would beToDays(ToDate([call attempt 1]) - ToDate([Date Created]))The above would be a formula numeric field.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Hi Mark,Thanks for having me break this down further as it made me realize there's actually 2 problems to solve for.Since there's no Call Attempt 1 data yet, let's look at this highlighted example...Here, I would want know that it took '1' or '1 day' between Call Attempt 2 and Call Attempt 3.It would also be useful to know that since Call Attempt 2 occurred on 08/17/2021, that x number of days has passed since the current date. This could help us know that it's past time for us to reach out again.Does that make sense?Thanks,Matt------------------------------Mathew Crist------------------------------

OK, try thisvar date TodayOrLastCallAttempt = IF IsNull([Call Attempt 1]),Today(), [Call Attempt 1]);Todays($TodayOrLastCallAttempt - ToDate (Date Created]))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Create a report that shows time between timestamps

22 Replies

MarkShnier__You
Qrew Legend
3 years ago
Can you give a couple of example of the data you have and the result that you want?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MathewCrist
  Qrew Member
  3 years ago
  
  Hi Mark,
  
  I'm trying to take account of how long we take to call someone from the time a lead comes in (Date created to Call Attempt 1). Beyond that, I would also like to determine how long it has been since the last attempt.
  
  Knowing this will give us more visibility as to:
  1) how long we generally take to reach out to our leads
  2) When it's time to try again (i.e. Call attempt 1 was 72 hours ago = time to try again).
  
  Thanks!
  
  Matt
  
  ------------------------------
  Mathew Crist
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Can you give me an example of a single record (say the first one on that list if you like) and the correct calculated result.
    
    If you just want to know the number of days, then it would be
    
    ToDays(ToDate([call attempt 1]) - ToDate([Date Created]))
    
    The above would be a formula numeric field.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Create a report that shows time between timestamps