Null Date

Jae.L

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

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

Hi @A.Aj,

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

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

@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!