3 Replies Latest reply: May 15, 2017 7:48 AM by Jonathan Dienst RSS

    Look up maximum date

    David Pardoe

      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.

       

      Any pointers?