What should be the results of this combination function add_bus_days(month_start(date()),1) Using the first day of each month for the year 2006?
Ending_Date = ADD_BUS_DAYS( Starting_Date as D, Add_Days as N [, Ignore_Holiday_Flag as C [, Holiday_Table as C ]] )
My Diagnostics shows incrementing the Add_Days by 1 for each of the 1-20 some work days in a month works except for when the first day of the month starts on a week-end then the Ending_Date is incorrect.
For the year 2006 I found the following; for Stating_Date being changed manually for the first day of the month (01/01/2006) or by changing the computer date for the first of each month using (month_start) both were the same results.
(The asterisks show the incorrect months with double asterisks showing also incorrect holliday calculation )
Starting_Date 01/01/2006 the result for Ending_Date = 01/02/2006
Starting_Date 02/01/2006 the result for Ending_Date = 02/02/2006*
Starting_Date 03/01/2006 the result for Ending_Date = 03/02/2006*
Starting_Date 04/01/2006 the result for Ending_Date = 04/03/2006
Starting_Date 05/01/2006 the result for Ending_Date = 05/02/2006*
Starting_Date 06/01/2006 the result for Ending_Date = 06/02/2006*
Starting_Date 07/01/2006 the result for Ending_Date = 07/03/2006
Starting_Date 08/01/2006 the result for Ending_Date = 08/02/2006*
Starting_Date 09/01/2006 the result for Ending_Date = 09/04/2006**
Starting_Date 10/01/2006 the result for Ending_Date = 10/02/2006
Starting_Date 11/01/2006 the result for Ending_Date = 11/02/2006*
Starting_Date 12/01/2006 the result for Ending_Date = 12/04/2006*
I maybe using this function with the wrong understanding?
Thanks for any suggestions or input.
Ending_Date = ADD_BUS_DAYS( Starting_Date as D, Add_Days as N [, Ignore_Holiday_Flag as C [, Holiday_Table as C ]] )
My Diagnostics shows incrementing the Add_Days by 1 for each of the 1-20 some work days in a month works except for when the first day of the month starts on a week-end then the Ending_Date is incorrect.
For the year 2006 I found the following; for Stating_Date being changed manually for the first day of the month (01/01/2006) or by changing the computer date for the first of each month using (month_start) both were the same results.
(The asterisks show the incorrect months with double asterisks showing also incorrect holliday calculation )
Starting_Date 01/01/2006 the result for Ending_Date = 01/02/2006
Starting_Date 02/01/2006 the result for Ending_Date = 02/02/2006*
Starting_Date 03/01/2006 the result for Ending_Date = 03/02/2006*
Starting_Date 04/01/2006 the result for Ending_Date = 04/03/2006
Starting_Date 05/01/2006 the result for Ending_Date = 05/02/2006*
Starting_Date 06/01/2006 the result for Ending_Date = 06/02/2006*
Starting_Date 07/01/2006 the result for Ending_Date = 07/03/2006
Starting_Date 08/01/2006 the result for Ending_Date = 08/02/2006*
Starting_Date 09/01/2006 the result for Ending_Date = 09/04/2006**
Starting_Date 10/01/2006 the result for Ending_Date = 10/02/2006
Starting_Date 11/01/2006 the result for Ending_Date = 11/02/2006*
Starting_Date 12/01/2006 the result for Ending_Date = 12/04/2006*
I maybe using this function with the wrong understanding?
Thanks for any suggestions or input.
Comment