Skip to Content
Former Member
Nov 10, 2008 at 11:31 PM

Nulls and SQL Date Fields


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)