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”.
The below is the condition in data source designer.
When i tried running the same condition by hardcoding all parameter in sql developer, the query runs successfully.
Can someone please help me with a solution.