How to convert currentStatusDuration to days in calculated column in textmode? | Community
Skip to main content
K
KristinaN
Level 2
October 10, 2024
Question

How to convert currentStatusDuration to days in calculated column in textmode?

  • October 10, 2024
  • 2 replies
  • 2033 views

Hello, I am looking to convert the developer object currentStatusDuration to days instead of hours as is default. When I run the below it is giving 0's so I think it is close but something must be off in my code. 

 

displayname=Days in Status
textmode=true
valueexpression=DIV({currentStatusDuration},24)
valueformat=double

 

2 replies

Sven-atClient
Sven-atClient
Level 3
October 10, 2024

Hi @kristinan 

try this? 

displayname=Days in Status textmode=true valueexpression=round({currentStatusDuration}/24,1) valueformat=doubleAsDouble

 

K
KristinaNAuthor
Level 2
October 10, 2024

Thank you so much, that ends up yielding 0.00 instead of just 0 but unfortuantely not doing any sort of calculation. Thanks!

A
AmyReilly
Level 4
October 15, 2024

Okay so it is on a report of Issues. I submitted a ticket with Adobe and they advised trying the below instead because the currentStatusDuration is a dynamic field. However this is yielding wonky results but at least it is not 0! 

 

It seems this gives minutes and converts to days but for the first line it has been 2 years since the update was made.

 

displayname=Days in Status
textmode=true
valuefield=currentStatusDuration
valueformat=compound#M:D

 

 

 


If you change the valueformat to compound#H:D, it gets closer.  However, the currentStatusDuration counts hours on a 24-hour basis, and this line of code converts the hours over to an 8-hr day.  

 

So, if a request is in a status for 30 hrs, that column should show up as 1.25 days  (30/24).  Instead, it shows up as 3.75 days (30/8).

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    September 1, 2025

    @kristinan just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...