cancel
Showing results for 
Search instead for 
Did you mean: 

Nulls and SQL Date Fields

Former Member
0 Kudos

Dear All,

I'm having a frustrating time dealing with dates in CR 11.5. I have situations where I want to have a date print (if there is a date) and be blank (or insert a tab character) if the field is null.

In my SQL tables, I see

1/1/1900 12:00:00AM

which I am given to understand is a null.

What I am looking for is a simple, preferably in the basic formula language, way to make comparisons based on this.

If it's not null, print the date (I'm using totext function) with the string template and that's working OK). If it's null, insert an empty string or a tab character, or whatever.

But whatever I try to do with the nulls doesn't seem to work.

I have researched in the forum history and found infomation about setting the "default" nulls, both in the report setting and in the formula window. I've tried using the IsNull function and don't seem to have a grasp of that.

Any assistance would be greatly appreciated.

Ridge (in New Joisey)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ridge

To check for the null values can you try one of the following formulas:

@Check Null 1:

Date({tablename.fieldname}) = Date(0,0,0)

OR

@Check Null 2:

{tablename.fieldname} < DateTime(0,0,0,0,0,0)

Let me know if this works.

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

We worked around it. Got good info and response was appreciated.