SQL Date/Time BETWEEN And Comparison Operators Work With Floats

ISNULL( date_ended, getDate() )

For Cut-and-Paste