Date in formula problem 1

[kphu]

Happy Holidays All!

Using access 2003.

Query formula.

YN: IIf([tablename]![DateOfService]>=10/10/2004,"y","n")

I'm getting "y" for everything even though the date of service field is < 10/10/2004.

Any help would be much appreciated.

Ken

 

[lespaul]

Is DateOfService defined as a date type?

Have you tried using the date delimiters?

YN: IIF(DateOfService >= #10/10/2004#, "Y", "N")



Leslie

 

[kphu]

Hi Paul,

Thanks for the response. I just tried it with the date delimiters. I forgot about that rule.

Its working now. Thanks for the help.

Ken