Date Iff question

[EllenM]

Hello,
I'd like for the date field to show up in one of two ways:
If before 1/1/2009, "Pre 2008"
If 1/1/2009 or after, I'd like to see the actual date shown.

Thanks in advance for your help.

Ellen

 

[RonaldoOneNil]

Create a textbox on your report and set the control source property to

=IIf([YourDateFieldName] < #01/01/2009# , "Pre 2008" , [YourDateFieldName])

 

[EllenM]

Thanks, Ronaldo!!