optimized view by date mehod