OTBI Global Level Function sysdate issue

Question

trying to get ssysdate from Global Value Functions by the following syntax but return null value, how can get the sysdate from Global Value Functions in OTBI( Fusion Cloud)

CURRENT_DATE

FORMAT_DATE(SYSDATE,'yyyymmdd')

FORMAT_DATE(CURRENT_DATE ,'yyyymmdd')

to_char(sysdate,'yyyymmdd')

how can achieve the sysdate in formate yyyymmdd from Global Values Function.

[Deleted User] · Answer

The only place for OTBI is Cloud Customer Connect:

https://cloudcustomerconnect.oracle.com/resources/a670a2ff88/summary

Maybe OP can get an answer there.

Gianni Ceresa · Answer

What about if you ask in an OTBI forum?

OTBI maybe use OBIEE as base, but has it's own things.

OBIEE in any screen where you can write a formula has a button 'f(...)' : do you have it? Click on it and go through the various entries till you find what you are after. If you don't have that button ask this thread to be moved in the OTBI forum as it isn't an OBIEE question (because NOW() is an OBIEE function).

user12879396 · Answer

I tried as above NOW() without quotes but getting the following error.

Formula Parser: Function {0} is not found.