nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

DVD Date Difference Calculation

Summary

DVD Date Difference Calculation

Content

New Calculation

(sysdates - entered_dt)

I get an error . Invalid expression

I need to find the days difference.

Find more posts tagged with

Accepted answers

All comments

TIMESTAMPDIFF

TIMESTAMPDIFF(SQL_TSI_DAY, tstmp1, tstmp2)

Another way will be to use CAST AS DATE and the CURRENT_DATE column given by DVD as below:

This will give you date differences.

hope this helps...