Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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));
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));
why not use the floor in the variable itself and use the variable itself in the where condition ?
regards
Pradosh
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.
Hi Pradosh, thank you for your time, i tried this but withou result. The problem was with variable type.