Max Date

[MikeC]

I have a form that I'm working on that has a couple of data bands in panels. In one of the databands I need to filter for only the max date on a field (property transfer dates). For example, the parcel may have several transfer dates but I don't want a list, I only want to pull a single record with the most current transfer date on it.

How do I set a filter on the data band that only pulls the max date?

[Ivan]

Hello,

Please do the following:
- set the Sort property of databand: your_date_field, Descending
- set the Filter property of databand: Field is "Expression", "YourDataSource.Position == 0"

Thank you.

[MikeC]

Thanks-that worked.

[Andrew]

Hello,

Thank you for letting us know about this.