Date format problem

[Warren Siu]

I've got two tables, say table1 and table2 and they have date type fields
[date1] and [date2] respectively. They are in Medium Date format. I've made a
loop on all records in table1 to get some records in table2 by matching of
[date1] to [date2].
Some expected records are missed at the result. I've tried to force the date
format to Long Date, but it didn't work.

 

[Douglas J. Steele]

The format shouldn't matter: dates are actually stored as 8 byte floating
numbers, where the integer part represents the date as the number of days
relative to 30 Dec, 1899, and the decimal part represents the time as a
fraction of a day.

Do you have times involved? That's more likely to be the problem, since
floating point numbers have round-off problems.