Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)') ;
Try this:
RESIDENT Depart
Where [When Found] = 'Production' and (Not IsNull(Branch))
AND Closed>= date('$(vReportYearStart)') ;