Condition on a date field

Fabio Pagano · Post by **Fabio Pagano** » Mon Oct 24, 2011 1:11 pm

In my records i have a field of "DateTime" type: i need to print it in red if its value is < today. In some records the date may be null.

I have tried to set a condition, but an exception is raised, probably caused by null dates.

Can you help me on how to print a datetime field in red if its value is < today?

Thank you.

Post by **Alex K.** » Tue Oct 25, 2011 1:21 am

Hello,

Can you please send us your report with test data for analysis.

Thank you.

Fabio Pagano · Post by **Fabio Pagano** » Fri Oct 28, 2011 1:39 pm

I try to explain without sending report and data.

Using version 2010.3.900.0 of 10 December 2010 in .NET Framework 2.0.

In my report i have a "datetime" column, called "Giro_Manutenzione_Automatica.Data_Ultima_Visita_Ispettiva", that i need to print in red if it is greater than "today" (or lesser than today, in my example i'm choosing "greater")

This datetime column may have null values in it.

In a text field i have put the following condition:

If i run the report, i receive the following error:

"Object reference not set to an instance of object":

with the following stack trace:

May you help me?

If necessary, i'll send you report and data.

-- I suspect the problem is caused by null dates, though i haven't had the possibility to do a test on it.

Thank you.

Post by **Alex K.** » Mon Oct 31, 2011 4:28 am

Hello,

We couldn't reproduce this bug.
Please send us your report with test data for analysis.

Thank you.