FDI Workbook should show NULLs for empty Date column cells, instead of "30/11/0".

User_M3T9S

In our FDI environments, have connected to the ADW to create custom subject areas.

We have many workbooks that contain date fields that often contain NULL values.

But in the FDI Workbooks, it displays "30/11/0" instead of showing the true null value.

Example:

Raw Data: "03/11/25"
FDI shows: "03/11/25"
Result: this is correct.

Raw Data: "null"
FDI shows: "30/11/0"
Result: this is incorrect, it should be null.

Service Request SR 4-0000929346 was created, where I was informed "This is an expected behaviour" and to log an ER.

Something this basic should be catered for out of the box, because as it stands, our users will see this "30/11/0" in our reports and become confused and lose confidence in our reports.

Thanks,