if condition with date

[surajap123]

Hi There,

I want to add date  to the WHOLE if condition below, ie date >=43871.  Please help

if(match(loc,'IND','US','AUS') AND (status = full and len(trim(scope))=0)
OR (len(trim(cde))=0 or len(trim(priority))=0 or len(trim(severity))=0), 1) as flag

[Kushal_Chawda · Accepted solution]

@surajap123  try below

if((match(loc,'IND','US','AUS') AND (status = full and len(trim(scope))=0)
OR (len(trim(cde))=0 or len(trim(priority))=0 or len(trim(severity))=0)) and Date >=43871, 1) as flag

[surajap123]

Thanks Kush