I am trying to get the maximum value for a variable that is being listed on
a report. The variable is not a column in the driving table it is a column
from another table. When I define the variable as:
vjrndate = max jrndate from AHISTORY where policy = policy
the response that I am getting is 12/31/4000 in all cases
When I try the same request from an r> prompt, I receive the correct
response - the maximum value for that column for that policy
r> select max jrndate from AHISTORY where policy = policy
Is there any way that I can get the maximum value to show up in the report
for a column which is not actually on the table that the report is driven
from?
