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!

Birthdays in Calendar?

leonhardtkFeb 12 2009 — edited Mar 24 2009
I'm new to APEX (and PL/SQL!), but i've created an test Application (Address book type).
All is going well, with some exceptions (I'll address the other later). My question right now is, I want to enter a birthdate (1/10/1962) in my record, but I want display "Birthdays" not the "Birthdate" on my calendar.

What I mean, is, If I have the Jan 2009 calendar, I want it to see that the date above will show up. What I don't want to do, is create another row for every year that the person could have (the examples I've found in the forum seem to do this). So I then want to be able to "click" on the "name" of the person that shows up on the calendar, and display the full record. I can do this part, I just haven't figured out how to display EVERYONE that has a JAN birthday, when I have the JAN calendar.

I guess it would have to have some logic in that if the birthdate field is "1/10/1962" and I have the "Jan 1961" calander, that birthday would not show up. I don't care that the birthdate shows up after "date of Expiration" (I.e. If I have the Jan 2099 calendar up, I still want my birthday to show up...just in case I'm still around!?!)

Appreciate any help.

leonhardtk.
This post has been answered by ATD on Mar 24 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2009
Added on Feb 12 2009
22 comments
2,140 views