I have a simple app to keep track of service ...

(Marius Scholtz) #1

I have a simple app to keep track of service repairs with a intake date. I want to see the age of each repair so I created a virtual column with the following formula…

=[Sent In Date] - (TODAY() + 1)

It is seemingly working but is returning the result in negative - hours. How can I change this to Days rounded off?

Thank you for any help.

(Marius Scholtz) #2

@Suvrutt_Gurjar Perfect, thank you so much. Wish I could understand the expression formatting on your level.

(Suvrutt Gurjar) #3

Thank you @Marius_Scholtz for update. Good to know the expression worked as per your needs.

(Suvrutt Gurjar) #4

Hi @Marius_Scholtz,Based on my understanding you wish to track the age of service requests that have been raised in the past. For example if today is 9th June and a service repair was logged on 3rd June ,then the Repair Age column Expression

should give a result of

6 (days). If the request was raised on 9th May , then the result should be 31 (days) and so on.

If my understanding is correct, you may wish to try the following expression in the virtual column

(HOUR(Today()-[Sent In Date]))/24

Please define the column as Number type

Hope this helps.