rolled back date CASE statement to raw dates in order to JOIN properly