Condtional Formatting Based On Time Difference

[Graham]

I want to do conditional formatting on a particular column called "HubArrival" which is DateTime format. I want it to have a pink background if the difference between HubArrival and BookedArrival is greater than 45 minutes, and I have set up conditional formatting to do this. Here is the code from the resulting designer file:

 

formattingRule2.Filters.Add(new Telerik.Reporting.Filter("AddMinutes(Fields.BookedArrival, 45)", Telerik.Reporting.FilterOperator.LessThan, "Fields.HubArrival"));

 

On running the report, an error occurs stating that DateTime cannot be compared with text - but both fields are of type DateTime.

[Graham]

Got there in the end. Needed to select <expression> on both sides of the inequality and also handle nulls. I ended up with...

 

formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= AddMinutes(IsNull(Fields.BookedArrival, AddDays(Today(), 5)), 45)", Telerik.Reporting.FilterOperator.LessThan, "= IsNull( Fields.HubArrival, AddDays(Today(), -5))"));

[Graham]

Got there in the end - had the select <expression> on ether side of the inequality, and handle nulls. I ended up with...

 

formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= AddMinutes(IsNull(Fields.BookedArrival, AddDays(Today(), 5)), 45)", Telerik.Reporting.FilterOperator.LessThan, "= IsNull( Fields.HubArrival, AddDays(Today(), -5))"));