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
  • 2034 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!

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

what about using string as format? 

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...