5 Replies Latest reply: Sep 15, 2014 9:05 PM by Marcus Sommer RSS

    Peek function returns the wrong Date

    Alan Farrell

      Hi All,

       

      I have following table

       

      Transaction:

      LOAD

        warehouse,

          DATE([date-added],'DD/MM/YYYY') AS Date

      FROM

      [P:\Qlikview Library\BESTWICKS\EXTRACT\BW\Transactions.qvd]

      (qvd);

       

       

      LET vMaxDateTime = Peek('Date',-1,'Transaction');

       

      However the variable is not returning the correct date

       

      It should be returning 29/05/2014 but it keeps returning 26/09/2013

       

      Any ideas?