Date problem on Report

[DeborahP]

I have a report that should print people with a hiredate of 11/01/03 with a certain number of training that should be completed and another number if their hiredate is less than 11/01/03.

=IIf([hiredate]<11/1/2003,1,2)

This is the statement I use and it is not working correctly. An example is I have a person with a hiredate that is 12/19/98 and I am getting the result of 2 instead of a 1.

What is wrong? I know I am missing something simple.

Thanks,
Deborah

 

[maxmangion]

try to enclose your date with #

i.e =IIf([hiredate]<#11/1/2003#,1,2)

 

[DeborahP]

Thank You!

I thought about that earlier because I have used it in a query to extract by date range however I neglected to use it on the report.

THANKS again!!!

Deborah

 

[maxmangion]

i'm glad that you managed to solve your problem!