IIf question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to write an IIf statement like this, but can't get it to work.

If [datefield], >1/1/2006, "new", else [datefield], <1/1/2006, "ongoing"

Can someone please help me with this statement.

Thanks!
 
Back
Top