Date Iff question

  • Thread starter Thread starter EllenM
  • Start date Start date
E

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
 
Create a textbox on your report and set the control source property to

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