Solved: Conditional Formatting in a Report

[GoKats78]

I have a report in which I have conditional formatting. For some odd reason, it does not seem to be working correctly in the "Extended Due Date" Field
Below is the conditional formatting I used; and below that is the report...Notice that 12/21/2012 and 10/10/2012 has had the "late" formatting applied incorrectly while the 09/24/2012 and 09/25/2012 dates are correctly.

I have tried both the Date() and the Now() ..with the same results


In both the source query and report the fields are formatted as "Short Date" and the field IS an result of a formula. It appears to work for most of the results but not all....

Formula from Source Query:

Extended Due Date: IIf([tbl_Max Due Date].[Max Due Date]>[Hidden Page Table].[Due Date],[tbl_Max Due Date].[Max Due Date],"")

http://i93.photobucket.com/albums/l55/cag45/late_zpsfbb19371.jpg


http://i93.photobucket.com/albums/l55/cag45/Report_zpsf65b6864.jpg

[potski]

Hi Gokats78,
Does it make any difference if you format your expression, to ensure it is still being seen as a date ?

For example:

format(IIf([tbl_Max Due Date].[Max Due Date]>[Hidden Page Table].[Due Date],[tbl_Max Due Date].[Max Due Date],""),"mm/dd/yyyy")

It's the only thing I can think of.

Potski

[GoKats78]

I found this fix to apply to the Conditional Formatting..

DateValue(Nz([Extended Due Date],"12/31/2099"))<Date()