nested IF statements error
Hi Team,
I am trying to execute the below if else condition with the attached data. but it is throwing
an error. Please help me in resolving the error.
*Code
if((column(“Purchase Order”)==“0”
column(“Purchase Order”)==“000000000000”) & (getYear(column(“DocDateType”)!=“1900”
getYear(column(“CreationDateFormat”)!=“1900”) )))
{
if(getYear(column(“321DateFormat”)!=“1900”))
{
column(“CDF&321”)
}
else
{
column(“CDF&101”)
}
}
else if((column(“Production Order”)==“0”
column(“Production Order”)==“000000000000”) & (getYear(column(“DocDateType”)!=“1900”
getYear(column(“CreationDateFormat”)!=“1900”) )))
{
if(getYear(column(“321DateFormat”)!=“1900”))
{
column(“DD&321”)
}
else
{
column(“DD&101”)
}
}
else
“99999”
}
Error
Attached the data: