NULL Dates

I am printing report from MS SQL SErver 2000 and one of the fields is a date which will be null until it is updated.

Currently the date if it is null is printing out as 30/12/1899 00:00:00. Can I print a blank if it is null and a date if it has a non null value? If so how it is best achieved? ;)

Comments

  • edited 5:25PM
    Please don't bother answering this as the answer lies with scripting.

    I have a more serious bug in that FR can't find a class ??!! (at least I hope its a bug and something stupid I have done) ;)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.