Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
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
------------------------------
MathewCrist
3 years agoQrew Member
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
------------------------------
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
------------------------------
- MarkShnier__You3 years agoQrew LegendOK, try this
var date TodayOrLastCallAttempt = IF IsNull([Call Attempt 1]),Today(), [Call Attempt 1]);
Todays($TodayOrLastCallAttempt - ToDate (Date Created]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MathewCrist3 years agoQrew MemberThanks Mark!
------------------------------
Mathew Crist
------------------------------- MathewCrist3 years agoQrew MemberWorking on it now... would this ideally be a summary report?
------------------------------
Mathew Crist
------------------------------