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
if(
isnull([discharge date]), Today()-[B2C Start Date],
[discharge date]-[B2C Start Date]
)
You'll have to capture the discharge date.