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 AI and Analytics

Child Item

get greatest of two dates in OTBI

Parthiban Vaithiyanathan-86705

Content

Hi,

I need to find greatest /least of two dates in OTBI using formula

how can we do this in OTBI?

Find more posts tagged with

Answers

OTBI

Analyses

Comments

Prudence K

Hi - assuming that the two dates are the same field, then you would do MAX("FIELD").

Parthiban Vaithiyanathan-86705

Hi - dates are in two different field

Wade Wilson

Are the fields dates or timestamps? Either way, you should be able to use TIMESTAMPDIFF and some CASE statement. Pseudocode below:

TIMESTAMPDIFF(SQL_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE),TIMESTAMPADD(SQL_TSI_DAY, 0, CURRENT_DATE))

...

CASE when (above formula >= 0) then date on right of method ELSE date on left of method END

Hope this helps.

Prudence K

OK, try this then:

CASE
WHEN "FIELD1" > "FIELD2" THEN "FIELD1"
WHEN "FIELD2" > "FIELD1" THEN "FIELD2"
END

[Deleted User]

Wait where's the ELSE? What if they're the same? :-P

Prudence K

You do not always need the ELSE on there, in this statement it would just return a blank cell.

If you want it to return something for it being the same, you would do something like this:

CASE
WHEN "FIELD1" > "FIELD2" THEN "FIELD1"
WHEN "FIELD2" > "FIELD1" THEN "FIELD2"
ELSE 'SAME'
END

When I tested this, it errored because FIELD1 and FIELD2 are dates ... so I had to use code like this:

CASE
WHEN "FIELD1" > "FIELD2" THEN 'Field 1 name'
WHEN "FIELD2" > "FIELD1" THEN 'Field 2 name'
ELSE 'SAME'
END

I am not sure how to combine the text/date fields for it to work.

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…