update to change endof day to end of yesterday