Font color change based on date value > 1 year.

[Dale123]

I'm new to Actuate Reporting and would appreciate some advise. I am trying to change the font color on data fields that are older than one year.

My code below is in the content frame properties of the table value field (CF_S_EVT_ACT.TODO_ACTL_END_DT -as date) that I would like dependant on the date.

The error is pointing to my date field. Error message is:
NewReportApp::Frame3::CFSEVTACTTODOACTLENDDTControl%OnRow%AcDataRow(3): Illegal variable use. - (CF_S_EVT_ACT)
NewReportApp::Frame3::CFSEVTACTTODOACTLENDDTControl%OnRow%AcDataRow(3): Operator not found for these types.
2 Semantic Error(s) found

------------------
Sub OnRow( row As AcDataRow )
Super::OnRow( row )
If DateDiff("YYYY", CF_S_EVT_ACT.TODO_ACTL_END_DT, Date()) > 1 Then
Font.Color = red
End If
End Sub

Thank You in advance, Dale

 

[DaveInIowa]

Try this:

If  DateDiff("YYYY", [COLOR=red]DataValue[/color], Date()) > 1 Then