Home > FAQ > Database > Comparing dates in two database files

Comparing dates in two database files

QUESTION: I used ProVal's Screen Data | Compare Database Files | Compare Fields command to compare last year's data to this year's data. However, because I have the exact date of birth in one file and assume the first of the month in the other, all dates of birth are showing up as different. Is there a way to compensate for this?

ANSWER: Yes. Run an absolute value (not percent) test using a minimum tolerance of -30 and a maximum of +30.