IIf question

[LisaK]

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!

 

[Ofer]

Try

IIf( [datefield] > #1/1/2006#, "new", "ongoing")