I'm trying to create a formula field that looks at a date field and if the dates are between two variable date fields which are the first day of the previous month and the last day of the previous month.  When I run the formula below I get nothing, when I know there are records in the date ranges specified.  Because I have ran a SOL query on the database and have received records back.

Formula script:
IF (({productionData.Date}) In (Date(11/1/2009) to Date(11/30/2009)))
THEN ({productionData.partsProducedLH} + {productionData.partsProducedRH})



Edited by aekelund - 09 Dec 2009 at 1:34pm

No I am not putting this in the select expert, this is a formula field.  I'm trying to add two fields together if the date on the record is between the first day of previous month and the last day of the previous month. When I try to do this it I get Zero's for all the records when I know there are records in the database for this time period.