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

current_date auto change when it's Monday

PJ CHEN

hi all,

I have a question about how to change the current_date,

I used CURRENT_DATE-2 to get the data,

however, I wounder can it auto update to CURRENT_DATE-4 when it's Monday

for example, in R , I will try like this :

if(weekdays.Date(Sys.Date())=="Monday"){

datadate <-Sys.Date()-4}else(datadate <-format(Sys.Date()-2)

Many thanks!!

擷取.PNG

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Hi,

you have a case statement in OBIEE

you also have a DayOfWeek function.

OBIEE: Calendar Date/Time Functions IN OBIEE

So, not hard to do the equivalent.

Joel Acha

You'll need something like this:

CASE WHEN DAYOFWEEK(CURRENT_DATE) = 2  THEN TIMESTAMPADD(SQL_TSI_DAY, -4, CURRENT_DATE)  ELSE TIMESTAMPADD(SQL_TSI_DAY, -2, CURRENT_DATE)  END

PJ CHEN

THANKS YOU SO MUCH!!!

PJ CHEN

THANKS!