Hi @Agnieszka Brela,

Welcome to the Oracle Analytics Community.

Please define your column as Date and it'll remove the timestamp. You can use syntax like following.

CAST(DUE_DATE as DATE)

DUE_DATE - Is the 'Due Date' Column.

Hope this help.

Thank you.

Try the below options:

1. Using SQL (TRUNC Function)

If you're writing a SQL query, use:

sql
SELECT TRUNC(learning_due_date), TRUNC(completion_date)
FROM learning_table;
This removes the time portion, leaving only the MM/DD/YYYY format.

2. Adjusting the Date Format in OTBI

In Oracle Transactional Business Intelligence (OTBI), you can modify the column properties:

Go to Column Properties → Data Format.
Select Date Format and choose a format that excludes time (e.g., MM/DD/YYYY).

3. Using CAST or TO_CHAR for Formatting

you can convert the date to a string format:

sql
SELECT TO_CHAR(learning_due_date, 'MM/DD/YYYY') AS Due_Date
FROM learning_table;