Let and Peek

[afbraga1]

Hello,

Got a question concerning Peek and Let statements. I have the code below but it is returning me in the trace  this - date(AddYears(YearStart(today()-1),-2),'YYYYMMDD'), when I expected to see a date.

LET v1 = Peek('Date', 'table1');

Trace $(v1);

Currently I have to do it in an extra step, in order  to have the date result calculated.

LET v1 = Peek('Date', 'table1');

LET v2 = $(v1);

Trace $(v2);

Thank you.

Best regards,

André Braga

[sunny_talwar · Accepted solution]

Try this

Table:
LOAD * INLINE [
    Date
    "Date(AddYears(YearStart(Today()-1),-2),'YYYYMMDD')"
];

LET v1 = Evaluate(Peek('Date'));

Trace $(v1);

[afbraga1]

Ah that was it! I totally forgot about evaluate() function. Thanks Sunny.