Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Oracle Fusion Analytics

FDI

Accepted answers

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.

All comments

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!

Jae.L

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

@Bhaskar Konar this worked, thank you.

Bhaskar Konar

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

Glad you found it helpful.

Thank you very much, @Jae.L!