IF Date Statement

[Noah114]

I have a query that utilizes a dateserial function to display dates as such

12/1/05
1/1/06
2/1/06

I'm trying to build an if statement that would state

=IIF([DATE]=12/1/05,1/1/06,[DATE]) but it stills displays

12/1/05
1/1/06
2/1/06

Any ideas?

 

[PHV]

=IIf([DATE]=#2005-12-01#,#2006-01-01#,[DATE])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886