I've created my first 2 charts, and they are almost lovely. For one of them, I need:
my query has a where clause stipulating that dt is greater than or equal to :P736_Start_Date
P736_START_DATE is Date Picker, with a SUBMIT BUTTON
the page item is set as Popup, with the format mask as MM-DD-YYYY
the page item goes into session state as: MM-DD-YYYY
the query works as expected
for a display label, I need the date formatted as 'DY DD-MON-YYYY' so I created a 2nd page item, with a computation, SQL QUery returning single value:
select to_char(:p736_START_DATE,'DY DD-MON-YYYY') from dual
and this just crashes the page....
Can you see what I'm doing wrong?
thank you
mt in NY