Forum Discussion

MathewCrist's avatar
MathewCrist
Qrew Member
3 years ago

Re: Create a report that shows time between timestamps

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
------------------------------

14 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
    • MathewCrist's avatar
      MathewCrist
      Qrew Member
      3 years ago

      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
      ------------------------------
      • MathewCrist's avatar
        MathewCrist
        Qrew Member
        3 years ago
        Also, 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
        ------------------------------