Time Conditional Format


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?
 
Ad

Advertisements

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top