Error in expression ')' expected

[Anonymous]

LET vMaxDateZ = floor(peek('MaxDateZ'));

if((program_date=date(floor(monthend(program_date)))) or (program_date=$(vMaxDateZ)),Qty,0) as qty.

I have created variable..it shows the error in variable nly.during reload..y and how to rectify this.but the exp is ok

.pls anyone help me thnks in advnce.

[Anonymous]

Hi,

The field MaxDateZ is loaded before LET? I am getting the same error only when is not a field name in the application or when the variable is first.

Best regards,

Cosmina

[sunny_talwar]

What is the error you are seeing?

[marcus_sommer]

You are missing the record and the tablename within the peek-function - it should look like:

floor(peek('MaxDateZ', 0 /* maybe also -1 */, 'YourTable'))

then if you used peek outside from a load those parameter are mandatory.

- Marcus