Skip to Content
-2

max date in infoset

Jan 13 at 08:38 AM

84

avatar image
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 ?

10 |10000 characters needed characters left characters exceeded

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.

1
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Jan 17 at 08:21 AM
0

Thank you and will try this.

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Jan 17 at 07:09 AM
0

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 )...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 21 at 12:28 PM
0

It has worked , appreciate the information provided.

Share
10 |10000 characters needed characters left characters exceeded