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!

Jae.L · Feb 3, 2026 4:43PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/74101#Comment_74101

@Bhaskar Konar this worked, thank you.

Bhaskar Konar · Feb 5, 2026 5:41PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/74285#Comment_74285

Glad you found it helpful.

Thank you very much, @Jae.L!

Oracle Fusion AI Data Platform Forum

Categories

Null Date

Best Answer

Answers