SQL Query (if/wildmatch)

[Jacob]

Hi everyone,

I have sql query and i trying to implement qlikview but i getting error.

SQL

(SELECT MIN(Adate) 
FROM xyz A1 
WHERE A1.dff=A.nid
P_number IN (58,656,46,49,10) ),'DD-MM-YYYY') NDate

 Expression

if(wildmatch(P_number , 58,656,46,49,10), Date(min(Adate )), DD-MM-YYYY) as NDate

anyone can plz help.

[dplr-rn]

what is the error?
quick look at the syntax is wrong. see below delete red and add green
if(wildmatch(P_number , 58,656,46,49,10), Date(min(Adate )), DD-MM-YYYY) )as NDate

[Jacob]

I am getting expression error

this is expression

if(WildMatch(P_number ,'58','6568','46'),Date(Min(Adate ),'DD-MM-YYYY')) as NDate