Help with Where

[eduardo_dimperio]

Hi ,

For some reason my clause WHERE doesn't work.

My code just ignore this clause as below

Code

vData=date(vData-dias);

NoConcatenate

Aux:

LOAD

OID_SYSTEM,

DATE_READ,

'$(vData)' AS TESTE

RESIDENT RS_INDIVIDUAL_READ

WHERE DATE_READ > FLOOR($(vData));

DROP TABLE RS_INDIVIDUAL_READ;

Output:

[sunny_talwar · Accepted solution]

May be try this

vData = Num(vData-dias);

NoConcatenate

Aux:

LOAD

OID_SYSTEM,

DATE_READ,

'$(vData)' AS TESTE

RESIDENT RS_INDIVIDUAL_READ

WHERE DATE_READ > FLOOR($(vData));

[pradosh_thakur]

why not use the floor in the variable itself and use the variable itself in the where condition ?

regards

Pradosh

[eduardo_dimperio]

Hi Sunny, thanks again for your help friend, that works... i was so distract about visual output that i didn't think about data type.

[eduardo_dimperio]

Hi Pradosh, thank you for your time, i tried this but withou result. The problem was with variable type.