3 Replies Latest reply: Mar 19, 2013 6:32 AM by Leni Balakrishnan RSS

    Issue in getting value using Fieldvalue

    Leni Balakrishnan

      Hi All,

       

      Below is the load statement I am using to get the first value from the table but I am not getting the appropriate value.

       

      Tb1:

       

      load date(floor(VALID_FROM)) as ValidFrom;

                SQL SELECT Max(VALID_FROM) as VALID_FROM

                FROM XXX

                WHERE CODE= 'aaaa';

       

      let LastDate = FieldValue('ValidFrom',1);

       

      Please help me to get this work

       

      ValidFrom has value 2013-12-28 but LastDate has 1905-05-23

       

      Thanks,

      Leni Balakrishnan