Hello,
I am passing date parameter but somehow it is not formatting date properly on calendars.
For e.g.
Below is my calendar query
select distinct count(*) knt, initcap(username) username, to_date(to_char(trunc(timestamp),'DD-MON-RR'),'DD-MON-RR') ts from xrx_master_records
group by initcap(username), trunc(timestamp)
In above query TS is the date column that results in DD-MON-RR format.
Then I format column on calendar tab as shown below, here is how I am constructing the link.
<!-- <a href="f?p=&APP_ID.:40:&APP_SESSION.::NO::P40_CAL:#USERNAME#:P40_DAILY_DATE:#TS#"
style="color:NavyBlue;
font-weight:bold">#USERNAME#(#KNT#) </a> -->
But the issue is - #TS# field shows complete date with time stamp for page item P40_DAILY_DATE. i.e. instead of 21-JUL-10, it shows 21-JUL-2010 12:00:00 AM. That means, it is ignoring calendar query and reads straight from database.
How can I make sure that P40_DAILY_DATE item receives date in DD-MON-RR format?
Then, I plan to use P40_DAILY_DATE to connect with the report region by comparing timestamp column from same table with P40_DAILY_DATE.
Please advice.
Thanks,
R