Selecting date from does not appear to work only for November 1st, 2020

There are many instances in the app where we need to select the previous date“s entry and populate - Example; populate with yesterday”s meter readings.

Originally, I used the Id field to identify the previous entry; however, sometimes we need to go back and add entries so this method did not work consistently. Now, I“ve tried using this code to select the previous entry based on date. It works well for everything but not for November 1st, 2020.

let prevdate := Date - 1;
”Pump1 (total hours)“ - max((select Water where Date = prevdate).”Pump1 (total hours)“)

Can anyone provide a suggestion or correction?

Cheers,