Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

MAX date

Simon Lord
 Share

This topic is 4618 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Simon Lord Newbie

Simon Lord

Posted
  • Newbies
Posted

Hi folks

I'm having a problem using the MAX calculation. I have one table linked to another via URN and I just want to select the max value in the linked table by the max (or latest) date. So, if on 18/2/11 I have a record with an N (in the approved field) but on the 23/2/11 I then have a Y in the approved field, how do I automatically select the Y?

I'm sure this should be simple and I know I've done it before...but it's just eluding me this morning and doing my head in!!

Is this the right forum to be asking for help?

Thanks all,

Simon

Link to comment
Share on other sites

This topic is 4618 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept