Date Calculation

[larkinw]

I have a table with field called REPORT DATE and another table with field EST REPORT DATE. I need to have query reflect NEW REPORT DATE. The results could either be a future date or a past date. I know I could come up with days between them being either a positive or negative number. But, I need the new report date not the number of days.

[Micron]

Why would you have dates that apply to any one report in different tables? Breaking up data like this is a common cause for roadblocks that db designers find themselves up against. If it has to be, then your query would need both tables, joined by whatever fields are common between them and a calculated field using IIF function to return whichever date is the max date - assuming that is the test.

[Welshgasman]

I have a table with field called REPORT DATE and another table with field EST REPORT DATE. I need to have query reflect NEW REPORT DATE. The results could either be a future date or a past date. I know I could come up with days between them being either a positive or negative number. But, I need the new report date not the number of days.

You have not even said how you are meant to calculate NEW REPORT DATE ?

[orange]

larkinw,
Welcome to the forum.
Can you step back a little and describe (in simple plain English) the "business process" that you are trying to support with a database? A little more context should help you get focused responses.