Error in expression ')' expected

[Anonymous]

Hai,

Load

Id,

qty,

Date

from (etc)

Max(Date) as maxdate

set vmax=floor(peek(maxdate));

if(programdate=Date or programdate=vmax,qty,0) as Qty

if i reload this script means it showing  Error in expression ')' expected.why this error is coming..thanks in advance

[sunny_talwar]

Can you check your variable by adding a trace statement

A:

LOAD Max(programdate) as MaxDate

Resident 1;

LET vMaxDate = floor(peek('MaxDate'));

TRACE $(vMaxDate);

EXIT SCRIPT;