Task Status report showing overdue task - Project 2007 Visual Report Visio

[davidp]

Hello,

Im trying to amend one of the Visual report templates to include a overdu
status on the task of my schedule. The overdue status will show if the
Complete is less than 100% and the Finish date is smaller than todays date.

I used the following formula but it does not work.
IF({Finish}<Now() AND {% Complete}<100%,0,1)

Please could you tell me what an I doing wrong.

Thank you in advance.
David