Skip to Content
Former Member
Jul 23, 2008 at 09:18 PM

Getting Unwanted Records In A Formula


Can someone tell why I'm getting records with no dates and data for the year 2007 when I enter a date range of 1/1/2008 to 5/31/2008 for the prompt (i.e. {?Closed Date}) ? The code used is below. Thanks ! ! !

{tracking_file_primary.F422#Closing_Date} in {?Closed Date} And IsNull({tracking_file_primary.FU035#Is_Portfolio_Loan}) Or

{tracking_file_primary.FU035#Is_Portfolio_Loan} = "No" Or

{tracking_file_primary.FU035#Is_Portfolio_Loan} = "N";