Duration Report End and Keep the value

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
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
Photo of Katie Griffiths

Katie Griffiths

  • 256 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

if(

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

[discharge date]-[B2C Start Date]

)

You'll have to capture the discharge date.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
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.
Photo of Katie Griffiths

Katie Griffiths

  • 256 Points 250 badge 2x thumb
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!!!!
Photo of Katie Griffiths

Katie Griffiths

  • 256 Points 250 badge 2x thumb
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:
Sum([BTC Discharge Date]-[BTC Admission Date])

and now I need to know how many of those days fall in each month.

I also have a simple duration report that I can pull from

Min(Today(),[BTC Discharge Date]) -[BTC Admission Date] 

What is the best way to calculate the days that occurred in a month?

Thanks in advance for the help.
Katie