Iif Statement

[ssworthi]

I am trying to designate a time status in a query. That everything before 3/28/11 is to be named "Pre" and everying after is to be called "Post".
This is what I have written but all the records say "Post". What am I doing wrong? Thanks so much as always!

Status: IIf([Date]=<3/28/11,"Pre",IIf([Date]>3/28/11,"Post"))

 

[boblarson]

you forgot the octothorpes (#) and don't need the other IIF (unless the field can be null).

Status: IIf([Date]=<#03/28/2011#,"Pre","Post"))

 

[ssworthi]

Thank you so much!