Issue in getting value using Fieldvalue

[Anonymous]

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

[#2]

Hi,

You can try writing the expression:

          =DATE(LastDate, 'YY/MM/DD')

I was facing a similar issue, but it was resolved when I used this expression while displaying the value in my listbox.

Hope this helps.

[#3]

Tb1:

load  max(date(floor(VALID_FROM))) as ValidFrom;

          SQL SELECT  VALID_FROM

          FROM XXX

          WHERE CODE= 'aaaa';

[Anonymous]

Hi All,

I just did a mistake.

I tried to show that variable in textbox so when I replaced let with set it worked.

Thanks all for your help