Where Condition

[smilingjohn]

Hi Expertise

I am writing the where condition please correct if this is wrong

RESIDENT Depart
Where [When Found] = 'Production' and Branch= not null
AND Closed>= date('$(vReportYearStart)') ;

The requirement is like found should be production and branch should not be blank and closed should be gretaer than startyear.

Thanks in Advance

[sivakumar1994]

Try this instead and let me know the status

RESIDENT Depart
Where [When Found] = 'Production' and Len(Trim(Branch)) = 0
AND Date(Closed) >= date('$(vReportYearStart)') ;

[dapostolopoylos]

Try this:

RESIDENT Depart
Where [When Found] = 'Production' and (Not IsNull(Branch))
AND Closed>= date('$(vReportYearStart)') ;