max date in infoset

[Former Member]

I am using table MARC and MBEW in a infoset and from table MBEW i want to get the max -Date of the last price change(field laepr) from mbew for the material linked to marc , can i do a select max (laepr) in the infoset field laepr ?

[Jelena]

Sorry but what's a point in asking "can I" when you could just try it and see if it works? It takes just as much time as posting a question here. Is there something specific you're afraid of? What's the worse thing could happen if you try? Questions like this are always very confusing...

You have our blessing if that's what you're asking for.

[raymond_giuseppi]

Yes you can, if aggregates are not sufficient, you could even play with subqueries...

Exercise: get some other fields values from the last changed record, the record where date = max( date )...

[Former Member]

Thank you and will try this.

[Former Member]

It has worked , appreciate the information provided.