IIF Condition with Incorrect Result

[DBFIN]

I have a POLEFFDATE field with dates in date/time format. A single record has POLEFFDATE equal to 12/15/2013. I calculated a simple field called EVALUATE as follows: IIF([POLEFFDATE]< 1/1/2014,1,0). EVALUATE should equal 1 for this record, but it equals 0. Why ?

 

[pbaldy]

Because it's not less than 1 divided by 1 divided by 2014.

IIF([POLEFFDATE]< #1/1/2014#,1,0)

 

[DBFIN]

Thanks Paul, this should resolve the issue.

 

[pbaldy]

No problem.