Conditional Formatting

[Guest]

I am fimiliar with using conditional formatting to highlight fields if they
meet a certain criteria. Although, one of my text fields contains the
following data:
"OBP 4.13.0 2004/01/19"
How do I configure this report to highlight fields that have a value
previous to 2005/01/01 given it is a text field?

 

[Marshall Barton]

I am fimiliar with using conditional formatting to highlight fields if they
meet a certain criteria. Although, one of my text fields contains the
following data:
"OBP 4.13.0 2004/01/19"
How do I configure this report to highlight fields that have a value
previous to 2005/01/01 given it is a text field?

This is another reason why there is a rule against having
multiple data items in a single field. But, if your table
design is not changable, you'll have to parse out the date
part of the data.

This can be easy if the date portion is always exactly the
last 10 characters. The Expression Is would then be:

CDate(Right(thefield, 10)) < #2005/1/1#