removed date() function in SQL throughout - broke graphs