Skip to main content

Hello,

I am facing an issue in the lobby while including the date parameter. The data is not populating in the lobby.

Cloud version - 23R1 

(Note - We need the date as a datatype to get the calendar below to pick the desired date from the calendar)
 



In the main view, the date (balance_date) is formatted as “DD-MON-YY”
The page parameter uses the format “YYYY-MM-DD”.

Subquery’s date (balance_date) is also formatted as “DD-MON-YY”.

The picture below shows the format as “DD/MM/YYYY”, but in reality, it is using the format “YYYY-MM-DD”.

Page Parameter

 

Lobby Page


The below is the condition in data source designer.
 

Data Source where condition

When i tried running the same condition by hardcoding all parameter in sql developer, the query runs successfully.

 

SS of Sql developer

Can someone please help me with a solution.
 

.

UPDATE

I tried the below conversion and it worked for me.

where TO_DATE(TO_CHAR(balance_date,'YYYY-MM-DD'),'YYYY-MM-DD') <= '$DATE$'

Reply


Terms & ConditionsCookie settings