Null Date

Jae.L · Jan 28, 2026 7:58PM

Hi All,

Null dates are displayed as 11/30/0 in my dashboard. How can this to be displayed as blanks.

Thank you

Bhaskar Konar · Jan 28, 2026 8:21PM

https://community.oracle.com/products/oracleanalytics/discussion/27979/null-date

Can you please try a CASE Statement like following to replace the value to null?

CASE 
    WHEN "Your_Date_Column" IS NULL THEN NULL 
    WHEN "Your_Date_Column" = TO_DATE('0001-01-01', 'YYYY-MM-DD') THEN NULL -- Handles potential '0000' dates
    ELSE "Your_Date_Column"
END

Hope this help.

Thank you.

Bhaskar Konar · Jan 28, 2026 8:28PM

Hi @A.Aj,

Additionally, it seems it is an expected behaviour and got the following Idea.

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

Please vote or comments.

Thank you.

RVohra · Jan 30, 2026 5:38AM

@Jae.L , in case, if this column is display only, then try to make it NULL safe, essentially if it is NULL then ' ' else use CAST function. Hope it helps!

Oracle Fusion AI Data Platform Forum

Categories

Null Date

Answers