Has Anyone Found a Way to Capture the Date a Status has Changed on a Calculated Field? | Adobe Higher Education
Skip to main content
JustinRenteria2
JustinRenteria2
Level 6
May 16, 2025
Resuelto

Has Anyone Found a Way to Capture the Date a Status has Changed on a Calculated Field?

  • May 16, 2025
  • 2 respuestas
  • 739 visualizaciones

We had a field that would capture the date a status changed but it looks like it's not working anymore.   The calc used the {lastNote}.{auditText} field to determine if the status was changed then it would record the date but this calculation no longer works (Not sure how long it hasn't been working for or perhaps it never worked, not sure).  Has anyone found a good method to record the date of the most recent status change?  I understand we can find it if we use a note report but Id like to have it on a calculated field. 

Mejor respuesta de skyehansen

I see. (i.e. Seems weird that no one has submitted a case with Support to investigate, but that's no longer pertinent to this post.)

 

So what I am hearing is that every time a status changes, you want to log the date. The below may or may not work, you'd have to test. If you choose to change over to using this though, it only applies to future changes. Everything that has already been changed will come up as n/a.

 

IF({status}={previousStatus},{DE:Last Status Change},$$TODAY)

2 respuestas

skyehansen
Community Advisor
skyehansenCommunity Advisor
May 16, 2025

If you can share the non working code, it would perhaps help us determine what it is that the field was trying to do. "status change date" covers a lot of possibilities, for example "date", "date and time", "first occurrence", "every occurrence", "last occurrence", and every combination of this list.

JustinRenteria2
JustinRenteria2Autor
Level 6
May 16, 2025

We were trying to track the date (no timestamp) that the latest issue status change occurred no matter what the status was (last occurrence). 

Code below. It searches for the "Status Change" verbiage in the {lastNote}.{auditText} field.

If "Status Change" was found, then it displays the Entry date of the note.

If the issue was just created, then it displays the object Entry date. 


IF(SEARCH("Status Change",{lastNote}.{auditText})>=0,{lastNote}.{entryDate},IF(ISBLANK({DE:Last Status Change}),{entryDate},{DE:Last Status Change}))

SIDE NOTE:  I tried to pull the {lastNote}.{auditText} field into a column on an issue report but it's always blank. This leads me to believe that the Audit text field is no longer supported or perhaps broken. I did do a search here in the community and it looks like the field hasn't been working for a few yrs according to a diff post. 
skyehansen
Community Advisor
skyehansenCommunity AdvisorRespuesta
May 16, 2025

I see. (i.e. Seems weird that no one has submitted a case with Support to investigate, but that's no longer pertinent to this post.)

 

So what I am hearing is that every time a status changes, you want to log the date. The below may or may not work, you'd have to test. If you choose to change over to using this though, it only applies to future changes. Everything that has already been changed will come up as n/a.

 

IF({status}={previousStatus},{DE:Last Status Change},$$TODAY)
    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    May 25, 2025

     

    Hi @justinrenteria2,

     

    I invite you to review my Targeted Auditing post which might be of use.

     

    Regards,

    Doug

    Términos y condicionesAccessibility statement

    Loading footer...