I am trying to build a database of historical events, but whenever I input the start date or end date of an event from another century, one day is automatically subtracted from the date for some reason. So, if I put in 12/12/1765, as soon as I leave the cell it transforms into 11/12/1765 and there is apparently no way I can correct this, even if I click on the correct date in the calendar. I don’t have this problem when I input dates from this year or in the future, and I don’t want to add a time field because the time is often not recorded. Is there any way I can fix this?
If anyone could help I would be so grateful!