0 Replies Latest reply: Mar 20, 2013 6:12 AM by Hennie Welman RSS

    Load Max(Date)

    Hennie Welman

      Hi,

       

      how can I load the 7 maximum dates in my table as 'n seperate field? My script expression currently looks as follows but I'm getting an error when reloading:

       

      [Dates]:

      LOAD [Sales Date],

                Max([Sales Date],7) as [Sales Date7]

      Resident [Sales table];

       

      I appreciate your response.