Date in conditional formatting

[Guest]

I'm trying to get a date to be red/green to indicate whether or not a
proposal is still valid.
Condition 1 Expression Is :-

IIf(Nz([PropSubDate])="","No
Date",(DateAdd("d",[ValidDays],[PropSubDate])))<Date()

Condition 2 Expression Is :-

IIf(Nz([PropSubDate])="","No
Date",(DateAdd("d",[ValidDays],[PropSubDate])))>=Date()

It doesn't seem to like Date() and tells me "The function you entered can't
be used in this expression".

I came up with this expression on my work pc today and it worked; I emailed
it home to tinker with it (you can't do enough for a good company) and I get
the above error.

Both systems are Access 2000 on XP Pro (work) & XP Home (home).

I'm obviously doing something very daft - can anyone help me.

Thanks in advance.


Andy

 

[Guest]

Found it - it was a missing reference file:-

mscomct2.ocx

http://support.microsoft.com/default.aspx?scid=kb;en-us;297381