6 Replies Latest reply: Nov 25, 2011 9:54 PM by Felipe Ruiz RSS

    Problem to get the last date with peek

    Felipe Ruiz



      I have the next table:


      Cod     Date

      1          2011-01-11

      2          2011-03-14

      3          2011-04-15

      4          -

      5          -


      I need to create a calendar, then i used this code


      LET varMinDate = Num(Peek('Date',0,'Key_Table_For'));

      LET varMaxDate = Num(Peek('DAte',-1,'Key_Table_For'));


      When i load the script i have a issue because the last record there isn't date.


      How i get the last date and no the last record ??