4 Replies Latest reply: Jul 23, 2014 5:05 PM by Jaime Aguilar RSS

    Declare variable works after binary load but not in original scipt

      Can anyone tell me why the segment of script below works after I do a binary load of a report but not when I add it to the end of the script for that report andh ow to fix it? I'm just trying to get the max of dates in the data we load.

       

      Temp:

      LOAD max(Date) as tmpMaxDate

      Resident table1;

       

      LET vMaxVesselDate = floor(peek('tmpMaxDate'));

       

      Drop Table Temp;