Time Conditional Format

  • Thread starter Thread starter Pietro
  • Start date Start date
P

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?
 
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
 
Back
Top