Between dates using Iif

[unique]

Sorry this might be an easy one for you guys - but im still new to access



im trying to do an Iif statement between two dates on a text box for a report

something like this


='Active ' & IIf(DateValue([InvoiceDate])>=DateValue('12/01/2007') AND DateValue([InvoiceDate])<=DateValue('02/01/2009'),'Yes','No')

is these correct as i cant get it to work

[InvoiceDate] is another field that is gets it datevalue from

Thanks guys

[RuralGuy]

Try:
IIf(([InvoiceDate]>=#12/01/2007#) AND ([InvoiceDate]<=#02/01/2009#),"Yes","No")