12 Replies Latest reply: Oct 3, 2016 7:32 AM by Miskin Mazgaonkar RSS

    Max date is not working

    Mohammad Sarif

      Hi All,

       

      I want to retrieve the max date from a QVD. Date is in YYYY-MM-DD HH:MM:SS format. Below is my code:

       

      Master:

      LOAD

         *

      FROM [lib://IT Standard Metrics/QVD\Combined_Result.qvd]

      (qvd);

       

      Max:

      load ([sys_updated_on]) as [Max_sys_updated_on]

      resident Master    ;

       

      Let  vMax = peek('[Max_sys_updated_on]',0,'Max');

       

      However vMax is not populating anything.

      Could you please help me on this?

      Thanks,

      Sarif