I am looking to write a formula that would return 1 Maximum date
only based on two tables. when I use Maximum in a formula it returns a value of "True/False" and/or a list of several dates including the max date.
Tables look like the following
Table 1 Table2
userid userid dates
joeuser joeuser 1/1/2000
joeuser 12/1/2000
I need to take the userid from table 1 and match it with the Max date in Table 2. Results would look like:
joeuser 12/1/2000
Additionally, supressing seems to leave me with blank fields but a maximum date. I dont want to see the blank fields
This is what I end up with given the following formula
{Table2.CredentialDt}=Maximum{table2.CredentialDt},{table1.userid})
Edited by CigJDD - 12 Jun 2015 at 4:00am
IP Logged
