Skip to Content
avatar image
-2
Former Member

max date in infoset

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 ?

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

3 Answers

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

    Thank you and will try this.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17 at 07:09 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21 at 12:28 PM

    It has worked , appreciate the information provided.

    Add comment
    10|10000 characters needed characters exceeded