Minus operation is not working

awalhashim — Sat, 16 Nov 2024 21:44:32 GMT

Hi i am working from backend to calculate the age of person.

so i get the Year of birth from their ID like this

if(LEFT(nric_number,2)>text(date(TODAY(),'YY')),'19'&LEFT(nric_number,2),'20'&LEFT(nric_number,2)) as YearID

Then i want to minus today date with year only like this.

text(date(TODAY(),'YYYY')) - if(LEFT(nric_number,2)>text(date(TODAY(),'YY')),'19'&LEFT(nric_number,2),'20'&LEFT(nric_number,2)) as Age

But is not working. Please help me.

Re: Minus operation is not working

santhiqlik — Thu, 13 Dec 2018 05:56:45 GMT

Can you try this.. converting both the expressions to numbers..

Num(date(TODAY(),'YYYY')) - Num(if(LEFT(nric_number,2)>text(date(TODAY(),'YY')),'19'&LEFT(nric_number,2),'20'&LEFT(nric_number,2))) as Age

topic Minus operation is not working in QlikView

Minus operation is not working

Re: Minus operation is not working