1 Reply Latest reply on Oct 3, 2013 8:45 AM by 8a75d916-d8a7-42a5-a5b3-d6bf1ee88862

    Custom Tabular Form with working days by quarter

    603536

      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!