Forum Discussion

brcrawford's avatar
brcrawford
New Member
1 year ago

Looking at 2 Date Columns and Using Earliest Time

I am looking for help with a formula that will look at two date/time columns and use the earlier time. For example, when calculating the length of stay, it is currently only using the registration d...
Need Help
rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
1 year ago

brcrawford ,

This SWITCH Statement should get you there:
LengthofStay = SWITCH(

                               TRUE(),
                             [Registration Date/Time] < [Triage Date/Time],  [Discharge Date/Time] - [Registration Date/Time],
                             [Discharge Date/Time] - [Triage Date/Time] ).

 

Basically an If statement to determine which is earlier.

Hope this helps.

Regards,