Conditional Statement with dates

[Leesha]

Hi,

I have query using the following conditional statement:

Timely: IIf([r_posocroc]>[soc_dt],"late","Timely")

Both fields are date fields. The query is not returning the info correctly. For example, in one case r_posocroc = 11/1/2011 and the SOC date = 3/1/2011 and its stating that its "timely" when in fact it should be "late". Am I missing anything in the statement?

Thanks,
Leesah

[HansV]

The expression looks OK. Are you absolutely sure about the dates? For example if r_posocroc were 11/1/2010 instead of 11/1/2011, you'd get "timely".

[Leesha]

Hi Hans,

I checked the format directly in the tables and they are set to date. I tried Timely: DateDiff("d",[r_posocroc],[socdate]) and the numbers come up correctly for the difference in days. I can use this as a work around, but just couldn't figure out why the conditional statement wasn't working. Unfortunately its a huge DB with SQL linked tables so there's really no way to strip down and upload.
Thanks,
Leesha

[HansV]

I understand why it is impossible to attach a sample of the data, but I have no further ideas without seeing them.

[Leesha]

I appreciate the help by looking at the statement.

Leesha