Hello Bryan. I am able to summarize dates with the "Maximum" option (even CHARs). There is another Summary option called "Nth Largest" and you can try using it with N=1. (I haven't tried it but it should work, too).
--- In vantage@yahoogroups.com, "bsapot" <bsapot@...> wrote:
>
> Hi,
> Does anyone know how to get the current supplier price for a particular part and supplier combination in a BAQ?
>
> I linked VendorPart to PartPlant and PartPlant to Part. When I run the query I get all prices regardless of effective date. I tried making VendorPart a summary table and using Maximum(EffectiveDate) but the maximum() function is only avaialble for numeric values.
>
> Thank you,
>
> Bryan Sapot
> Datix, Inc
> bsapot@...
>