Date Criteria

[DSmith]

What criteria would you use to pull up the latest date in a series of dates?
Thanks.

 

[Dan S.]

You should be able to use an aggregate function, and look
for the Max record in the field. Just hit the Sigma button
(looks like a weird E) to view the grouping, and select
Max to retrieve the maximum (most recent) date in that
field.

HTH,

Dan.