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

    Problem to get the last date with peek

    Felipe Ruiz

      Hi,

       

      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 ??

       

      Thanks.