changed yesterday to -1 day offset instead of -86400 to ensure accurate day calculation during the day of DST change