Hi everyone. I need help.
How can I display, in a virtual column, the difference between NOW() - [request date] as the result? The result I expect is the number of days of delay.
(TOTALHOURS(TODAY() - [request date]) / 24.0)
2 Likes
Steve, I greatly appreciate the quick response. I was so happy about that!
I managed to solve it like this:
IF([STATUS]=“DP ANALISANDO”,HOUR([DATA SOLICITAÇÃO]-NOW())/24+1,“”)
1 Like