Time Conditional Format

[Pietro]

Hi,
I'm trying to make a conditionsal format for the the field "Dueto"
formatted as General date.

I chhose in the conditional format screen "Expression is" then put the
below expression:
format([Dueto],"Long Time")<[forms]![passme]![start] or format([Dueto],"Long
Time")>[forms]![passme]![end]
to make the field "dueto" become red.
Note that [forms]![passme]![end] is formatted as Long time while [dueto] is
a general date that's why i'm using the format equation.
Can anybody help?

 

[Clifford Bass]

Hi Pietro,

As long as Dueto is a date field, you should not need to do the
formatting. That changes the comparison to a text comparison. If one or
both are text you can use the CDate() function. CDate([Dueto]) <
CDate([forms]![passme]![start]).

Hope that helps,

Clifford Bass