Stop counting duration after a final date is put in

Question

Hello,&nbsp;
I have 2 date fields, one of which calculates a duration in another field based of the initial date entered. I would like the duration field to stop counting once the second date field is completed.&nbsp;
Primary date field is named Admission date
Duration field is named LOS
Secondary date field is named Discharge / Transition Date
I'm unsure how to set this up.&nbsp;
------------------------------LB------------------------------

chayceduncan · Answer

Something like this should work:&nbsp;

if( isnull([Discharge/Transition Date]), Today(), [Discharge/Transition Date]) - [Admission Date]------------------------------Chayce Duncan------------------------------

donlarson · Answer

LB,

I am assuming that the Discharge and Admission are each entered at very different times in the work flow.

LOS, Length of Stay?

If( isnull([Discharge])=true,&nbsp; Today()-[Admission], [Discharge]-[Admission])&nbsp; &nbsp;
------------------------------Don Larson------------------------------

Forum Discussion

Stop counting duration after a final date is put in