Forum Discussion

LB's avatar
LB
Qrew Trainee
3 months ago

Stop counting duration after a final date is put in

Hello,  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 c...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
3 months ago

Something like this should work: 

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



------------------------------
Chayce Duncan
------------------------------