This discussion is archived
1 Reply Latest reply: Oct 3, 2013 1:45 AM by 8a75d916-d8a7-42a5-a5b3-d6bf1ee88862 RSS

Custom Tabular Form with working days by quarter

603536 Newbie
Currently Being Moderated

Hi All, I'm trying to create an application to improve an old excel that some people use in my office. I came across a challenge: create a page when a user can submit for each business day the amount of hours worked, the real problem is that I have to show on the same page 40 business days that need to be dynamic, I mean that there is a "period" table that has a start date and end date, the range between those two MINUS the Saturdays and Sundays should be the amount of COLUMNS that the report show.

 

create table CT_PERIOD(

PERIOD_ID VARCHAR2(6),

PERIOD_FY VARCHAR2(4),

PERIOD_QUARTER VARCHAR2(1),

PERIOD_START_DATE DATE,

PERIOD_END_DATE DATE,

PERIOD_DAY_COUNT NUMBER,

)

 

insert into ct_period values ('1', 'FY14', 'Q1', to_date('01-JUN-2013', 'DD-MON-YYYY'), to_date('25-AUG-2013', 'DD-MON-YYYY'), 56);

commit;

 

I searched in the web for some example of this with no luck, if somebody did something like this or knows where I can see an example that would be great!

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points