DATE_FIX_FIRST returning no results. | Community
Skip to main content

DATE_FIX_FIRST returning no results.

  • September 19, 2022
  • 1 reply
  • 0 views
CJ99

Hi Folks, 
I'm completely stumped on why I can't get values to return for this formula. It should return the first timestamp where an agent updated with a public comment: 

IF 
[Comment public] = TRUE and [Updater role] = "agent" 
AND
DATE_FIRST_FIX([Update - Timestamp], [Updater role],[Comment public])
THEN
[Update - Timestamp]
ENDIF



This consistently returns no values, no matter what I do. Am I missing something here? 
I even got it down to a single ticket with a clear correct date that should return, and it says there's no tickets. I have no filters that can be interfering: 


It's literally just a single ticket ID so that the results are nice and small. Why does this return no data when I add the custom attribute? 

    1 reply

    CJ99
    • CJ99
    • Author
    • September 19, 2022

    For some reason, this version works: 
    IF ([Comment present]=TRUE
    AND [Comment public]=TRUE
    AND DATE_FIRST_FIX([Update - Timestamp],[Update ticket ID],[Comment present],[Comment public])=[Update - Timestamp])
    THEN [Update - Timestamp] ENDIF

     

     

    I just copied the guide for the first internal timestamp to get here. I'm not super clear on why "update ticket id" has to be included but if this works, then I'm good. 

    Terms & ConditionsCookie settingsAccessibility statement