Hi,
I want to make my Date Prompt in my prompt page only show Month and Year (because the date value have to be 25).
I try to custom the Date Prompt, but I can't find any settings to fulfill my requirement.
Any suggestion?
Should I use Value Prompt? But how to implement it?
Thanks for your kindly response.
Regards,
RD
Hello Radekus!
Your problem could be solved by using Value Prompt which would get your wanted dates from a query.
For instance, this would be query for Oracle DB which gets dates as you have descibed it, bounded with today's date and 01.01.2008:
SELECT report_date,
TO_CHAR(report_date, 'yyyy-mon') AS prompt_date
FROM (SELECT ADD_MONTHS(TRUNC(SYSDATE, 'MONTH'), -TRUNC(MONTHS_BETWEEN(SYSDATE, TO_DATE('2008-01-01', 'yyyy-mm-dd'))))
- 1
+ ROWNUM AS report_date
FROM all_objects
WHERE ROWNUM <= TRUNC(SYSDATE) - TO_DATE('2008-01-01', 'yyyy-mm-dd')) base_data
WHERE report_date <= SYSDATE
AND EXTRACT(DAY FROM report_date) = 25
When tying value prompt to results of the query, you should choose report_date for Use Value Property, and prompt_date for Display Value Property.
Hope this helps! :)