4 Replies Latest reply: Feb 6, 2018 9:25 AM by Hartley Julian RSS

    Strange Peek() behaviour

    Hartley Julian

      Hi All,

      Can anyone explain this!

       

      I have a table loaded as below

      MxDate

      43008

      42978

      42916

       

      If I put this field in a list box and sort by 'load order' and show frequency I only have single values in the order shown above.

       

      I have lines in my scrips as below:

      let vRepDate = Peek('MxDate', 0);

      let vRepDatePrior= Peek('MxDate', 1);

       

      This returns vRepDate = 43008 (correct)

      but vRepDatePrior = 42916 !!

       

      I don't understand....