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

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

  • October 10, 2024
  • 2 replies
  • 2031 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

kautuk_sahni
kautuk_sahni
Employee
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
Sven-atClient
Sven-atClient
New Participant
October 10, 2024

Hi @kristinan 

try this? 

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

 

K
KristinaNAuthor
New Participant
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!

Sven-atClient
Sven-atClient
New Participant
October 10, 2024
displayname=Days in Status textmode=true valueexpression=round({currentStatusDuration}/24,1) valueformat=string

what about using string as format? 

Terms & ConditionsAccessibility statement

Loading footer...