Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Advance APEX Calendar by "Next Year" or "Prev Year"

leonhardtkMar 19 2009 — edited Mar 27 2009
I have a standard calendar, and I've added two buttons:

[<< Prev] and [Next >>], on either side of the [< Prev] and [Next >] buttons that currently exist.

I want these to two new buttons to advance the calendar by "years" not "months".

I'm new to APEX and SQL, but learning as I go! My first thought is, duplicate the existing "next" and "Prev" processes on the page that currently advance the calender by 1 month, and advance by 12 months.

The problem is, When I look at the source of these buttons, they point to the following processes as applicable:

htmldb_util.increment_calendar;
htmldb_util.decrement_calendar;

I can't find where this "process" resides in the file system, or how it's passing data to the process (for example, the "Next" process should be telling the htmldb_util.increment_calendar function to increment the Px_CALENDAR_DATE by 1 month, and the "Prev" process should decremrement by 1 month.

Any ideas on how to either use htmldb_util.increment_calendar to increment by 12 months, or copy the process and modify to advance by 12 months?

Appreciate any ideas (Though it does seem this should have been a standard).

One alternative, any way to use the "Date Picker" format (Where you pick the Month AND the YEAR), then select a "Go" button?

Again, Appreciate any ideas!

KSL

Edited by: leonhardtk on Mar 19, 2009 2:03 PM
This post has been answered by ATD on Mar 21 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2009
Added on Mar 19 2009
26 comments
1,885 views