optimize dashboard date lookup