cancel
Showing results for 
Search instead for 
Did you mean: 

Why Is There No Return Value

Former Member
0 Kudos
76

Why is there no return value of "C" for records with nothing in this date field ? I am receiving no errors.

StringVar TagType;

If IsNull() Then TagType := "C"

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks ! ! !

Former Member
0 Kudos

1. Are you sure there are null dates in your table?

2. See if under File | Report Options, the box next to 'Convert Database NULL values to default' is checked. If it is, then NULL values have been converted and that could be a reason why the IF statement seems as though it is not working.

3. Try altering your if statement to:

If IsNull() or = date(0,0,0)

Then TagType := "C"

Former Member
0 Kudos

Thanks ! ! !

Former Member
0 Kudos

Raghavendra,

This did not work. is a date formatted column. The error message given is 'A date-time is required here.'

Former Member
0 Kudos

Hi,

Try using the below condition

if isnull( = True then

Your Statement;

This should work for you!!

Regards,

Vinay

Former Member
0 Kudos

In the formula editor at the top you can see a drop down list with values "Exception for nulls" and "Default values for nulls". Set this to "Default values for nulls" and try the following formula

StringVar TagType;
If ({Closing_Date})="" Then TagType := "C"

The formulas won't execute if the values are nulls.

Regards,

Raghavendra