daily dacor

updated sql to properly pull the transmitted date and not the requested
date