Couple of things from a fellow legacy application support type
You can still use the column "date", just surround it with square brackets. I.e.
update scans1 set [date] = '2019-07-31T00:00:00.000' where id = 21570
I was still getting an error until I changed it to
update scans1 set [date] = CDate('2019-07-31') where id = 21570