Pick the most current date

[sdimaggio]

I have a report that has a date column. I want to pick the last date out of the column and subtract it by a different date to figure out the number of days.

example:

Arrival Date: 9/25/04

Delivery Date
10/1/04
10/15/04
10/30/04

What I want is as follows:

10/30/04 - 9/25/04 = 36 days

I'm looking to put the formula inside the report.

Thanks

 

[flyover789]

sumething like:

= max([Delivery Date])-[Arrival Date]

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

 

[sdimaggio]

That did it! thanks