Discussions

Expand all | Collapse all

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:
    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