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

[JustinRenteria2]

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. 

[skyehansen]

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]

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 · Accepted solution]

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)

[Sven-iX]

Hi @JustinRenteria2 
Skye's solution works great - you can even expand on it by concatenating status, previousStatus and $$TODAY.

You can make this a "log" of sorts by adding the currentField value to the concatenation, then you'll have a calculated field Last Status Change" that might look like

2025-05-21: changed from NEW to CPL

2025-05-20: changed from INP to NEW

2025-05-20: changed from NEW to INP

[Doug_Den_Hoed__AtAppStore]

Hi @JustinRenteria2,

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

Regards,

Doug