Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Tb1:
load max(date(floor(VALID_FROM))) as ValidFrom;
SQL SELECT VALID_FROM
FROM XXX
WHERE CODE= 'aaaa';
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