I am trying to understand the logic behind date and time fields. When I have a field in one table that is just set as a DATE (no time), and I do a lookup of that date in another table with just DATE (no time), it adjusts the date to be one day before...