Duration Report End and Keep the value
Hi I have a simple formula: Today()-[B2C Start Date] calculating for a Duration Field. However once the person discharges, I would like the duration report to stop counting and retain the value w...
Forum Discussion
There are a bunch of ways to do this, but here is the shortest formula
Min(Today(),[B2C Discharge Date]) -[B2C Start Date]
It presumes though that you do not post date ahead your planned terminations.
Min(Today(),[B2C Discharge Date]) -[B2C Start Date]
It presumes though that you do not post date ahead your planned terminations.