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.




      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



      Leni Balakrishnan