# Discussions

View Only

## Duration Report End and Keep the value

• #### 1.  Duration Report End and Keep the value

Posted 12-15-2017 21:06
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 when the [B2C Discharge Date] is entered.
Is there a way to do this?
Thank you!
Katie

• #### 2.  RE: Duration Report End and Keep the value

Posted 12-15-2017 21:09
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.

• #### 3.  RE: Duration Report End and Keep the value

Posted 12-15-2017 21:09

if(

isnull([discharge date]), Today()-[B2C Start Date],

[discharge date]-[B2C Start Date]

)

You'll have to capture the discharge date.

• #### 4.  RE: Duration Report End and Keep the value

Posted 12-15-2017 21:18
IT WORKS!!!! I love trying to figure this stuff out-but you just saved me a bunch of work-I promise to keep learning-but thank you in the meantime!!!!
So exciting and cool that you can speak in this "language"
Cheers!!!!

• #### 5.  RE: Duration Report End and Keep the value

Posted 01-17-2018 19:18
Not sure if I can ask a question from here again? Going to keep in the same thread-as it is about the same formula(s)

I have the formula: