Simple Expression has me stumped

[m17347047711116]

Query has 3 fields

[Due Date], [Run Date], [Fin Date]

Exp:[Due Date]-(Max[Run Date],[Fin Date])
The above is the expression that is not working in my query, below is some sample date that demonstrates what I am looking for

[Due Date].......[Run Date].......[Fin Date]
[Jan 20 09].......[Jan 13 09]......[Jan 18 09]

Returned value from the expression on the above sample would be "2"
any ideas?

 

[pbaldy]

You can't find the max that way. Try this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857

 

[raskew]

Hi -

Give this a try as a calculated field in your query.

Exp: DateDiff("d",Iif([run date]>[fin date],[run date],[fin date]),[due date])

HTH - Bob