This content has been marked as final. Show 3 replies
I have a transaction table where each transaction has a date: TRAN_DATE
This table is linked to a date look up table which gives me our company time period that a date belongs to; this table has fields TRAN_DATE and TIME_PERIOD
The lookup table includes dates into the future so when I use the expression max(TRAN_DATE) I get the latest date in the look up table. I really want the maximum date in the transaction table.