updated GetByDate apis