Conditional Formatting Based on Timestamp

[sherlocked]

All,

I'm trying to conditionally format a field on my report based on the time portion of a date/time field. See below for my syntax. For some reason, the formatting is applying across the board regardless of whether the value in the field meets the conditions below. Any ideas? What am I doing wrong? :banghead:

[Time IN]<#6:00:00 AM# Or [Time IN]>#6:00:00 PM#

Your help is greatly appreciated!

 

[arnelgp]

use TimeValue.

i think you mean:

[Time IN]>Date() + #6:00:00 PM# And [Time IN]< Date()+1+#6:00:00 AM#

 

[sherlocked]

Not quite. The date portion of the field is a range that falls within the critera of the query my report is based on. I don't care what the date is; I only care if the time portion of the field is before 6am or after 6pm.

 

[sherlocked]

Anyone? I tried the solution suggested but nothing. I'm desperate!

 

[arnelgp]

dont care about the date, then it would return all records with that condition.