Date Format 30.12.1899

Hi,

Default null date value is 30.12.1899. This value is printing on the report.
How can I do set this value ' ' on before print event;

Fr2.53 value.

Regards,

Athena.




Comments

  • gordkgordk St.Catherines On. Canada.
    edited 5:52PM
    generally in the obp event of the band check the datafield using the fieldisnull function provided and turn visibility of the memo on or off
    or in the memo itself use a complex if function checking the datafield for null in the expression portion and returning '' or 'some text' in true value param and the '[tblname."fieldname"]' in the false value param
    beware of the field is null function when [tblname."fieldname"] is placed in it, it must be in the form of and if built using the expression builder these extra apostrophes will not be present.
    ;)

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.