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