How can I calculate a Date first Solved for an attribute?

Answered

3 Comments

  • Brett Bowser
    Zendesk Community Team

    Hey Hillary,

    Apologies for the delayed response! You could probably use this formula and just substitute first resolution time in place of first reply time.

    The formula would look like the following:

    IF (VALUE(First resolution time (min))!=NULL AND VALUE(First resolution time (min))>0 )
    THEN DATE_FORMAT(DATE_FROM_TIMESTAMP(NUMBER(DATE_TO_TIMESTAMP([Ticket created - Timestamp]))+VALUE(First resolution time (min))*60),"YYYY-MM-dd HH:mm:ss")
    ELSE "-"
    ENDIF

    Hope this helps!

    0
  • Hillary Latham
    Community Moderator

    Thanks Brett.  This is working for me!.  I was on the right track...just couldn't get there.

    0
  • Brett Bowser
    Zendesk Community Team

    Happy to help Hillary!

    0

Please sign in to leave a comment.

Powered by Zendesk