Null date field not showing blank in report

taylor

There is a date field in the form. In some use cases, the date field is not used and is set as null. In the report, it shows the date as 1/1/1753 . How can I make it showing blank if no date is entered in the date field?

Kathryn_Decisions

This date is a representation of Null within the SQL database. To have this display correctly in Decisions, we'll need to edit the data structure in question and allow the field to be null.

To do this, edit the data structure that is storing this value, click on the date field in question, then enable the Allow Null (No Value) boolean. Save and close the form, and that's it! Unfortunately, this will not affect previous entries, those will need to be replaced or edited.