This content has been marked as final. Show 3 replies
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
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