Forum Discussion
MathewCrist
Qrew Member
Hi Mark,
Also, I'm getting an error message with the code you provided...
If I update to add the ( in front of IsNull ...
...I still get an error that the field is not identified.
If I change to the name of the timestamp field which is "Call Attempts Timestamp - Message 1" I still get the 'Field is not identified' error message.
Any advice?
Thanks,
Matt
------------------------------
Mathew Crist
------------------------------
Also, I'm getting an error message with the code you provided...
If I update to add the ( in front of IsNull ...
...I still get an error that the field is not identified.
If I change to the name of the timestamp field which is "Call Attempts Timestamp - Message 1" I still get the 'Field is not identified' error message.
Any advice?
Thanks,
Matt
------------------------------
Mathew Crist
------------------------------
MarkShnier__You
3 years agoQrew Legend
The formula builder box allows you to choose fields from a drop down list. I suggest that you use that feature to get the correct field name.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MathewCrist3 years agoQrew Member
Thanks Mark. I appreciate your help. I think once I get the formula worked out I can figure out the rest.
Can you confirm that a Summary report makes the most sense for this type of request? Or, did you have something else in mind?
------------------------------
Mathew Crist
------------------------------ - MathewCrist3 years agoQrew MemberAlso, I think I located the correct field name, but now getting this error...
The field type is Date / Time, so it makes sense, I'm just not exactly sure how I need to modify the code:
------------------------------
Mathew Crist
------------------------------ - MathewCrist3 years agoQrew MemberI figured out that I need to define summary variable in order for them to show in the list.
So, here's where I'm at:
Also, not really sure if should be choosing distinct count for everything, but it sort of makes sense to do so...
------------------------------
Mathew Crist
------------------------------ - MathewCrist3 years agoQrew MemberI'm figuring out that I may need to change the field type to Date, instead of Date/Time. Before I do that, I wonder if there's any way to determine # of Days (or number of hours even) from the Date/Time field?ā
------------------------------
Mathew Crist
------------------------------ - MarkShnier__You3 years agoQrew LegendI'm not understanding the question, but the syntax ToDate([my date / time field]) will convert a date / time field to just the Date if used in a formula date field.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - MarkShnier__You3 years agoQrew LegendNow completely lost as to what you're trying to do. I thought you were simply trying to find the duration between two fields on a single record. So I don't know why you feel you need to have a summary report.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - MathewCrist3 years agoQrew MemberSorry, I thought it was clear that I was talking about a report. Here's the original question...
I need to calculate the time between 2 timestamps
Time 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)?
Simply put, I'm wanting to keep track of the time between events.
I think I understand where you're going with this. You're suggesting creating a new Formula - Numeric field, instead of a report right?
And from there, I can create a report that filters by the number of days. That works too. I just need to get the formula to work and having trouble with what you provided. Let me give that a try...
ā
------------------------------
Mathew Crist
------------------------------ - MarkShnier__You3 years agoQrew Legendyes, you need to create a formula numeric field with a formula like this one, but using tour field names.
var date TodayOrLastCallAttempt = IF IsNull([Call Attempt 1]),Today(), [Call Attempt 1]);
Todays($TodayOrLastCallAttempt - ToDate (Date Created]))
Then once you have the calculated field, it easy to make a regular Table report to look for calls due to be followed up.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - MathewCrist3 years agoQrew MemberSame issue when creating a Formula - Numeric filed type:
Getting the error that it is "expecting date but found datetime."
------------------------------
Mathew Crist
------------------------------ - MarkShnier__You3 years agoQrew LegendIf you copy and paste you formula I can edit it. I can't edit a screen shot.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------