Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Holiday tabel problem.

Status
Not open for further replies.

mverkruijssen

Programmer
Mar 11, 2002
34
NL
Does anybody know if there is an issue regarding holiday table's?
It seems that it doesn't always works correctly.
I programmed it for a customer, so he could play an announcement during the move to a new office.

I programmed it like this:

HOLIDAY TABLE
Number: 3 Name: Vrij Uit
______START_______ _______END________
Month Day Hour Min Month Day Hour Min Description
03 22 21 30 03 23 23 59

During testing friday evening it worked fine, but saturday tha calls were routed like the should during opening times on that day.

When I changed it to the following it worked fine:

HOLIDAY TABLE
Number: 3 Name: Vrij Uit
______START_______ _______END________
Month Day Hour Min Month Day Hour Min Description
03 23 11 00 03 24 23 59

When I chamge the and time earlyer than 11:00 hours, it seems to follew the vector in stead of following the holliday tabel.

Anyone any idea's???
 
Sorry Michel,

I don't think you read the book correctly.... Or maybe didn't read it at all. I have to admit neither did I till you mentioned this problem over the phone to me. But it is mentioned in the book.

This are the rules you have to follow while using holiday-vectoring:
The Holiday Table Form can be used for entering individual holidays or holiday ranges.
The following rules apply to entering dates on this form:
1. If a day is entered, the corresponding month must be entered.
2. If a month is entered, the corresponding day must be entered.
3. If an hour is entered, the corresponding minute must be entered.
4. If a minute is entered, the corresponding hour must be entered.
5. If an hour and minute is entered, the corresponding month and day must be
entered.
6. If a month and day is entered, the corresponding hour and minute is not required.
7. If an end month and day is entered, the corresponding start month and day must be
entered.
8. If a start month and day is entered, the corresponding end month and day is not
required.
9. To enter an individual holiday, enter a start month and day, but do not enter an end
month and day.
10. To enter a holiday range, enter both a start month and day and an end month and
day.
11. The start month, day, hour, and minute must be less than or equal to the end month,
day, hour, minute.
12. The description field is an alpha-numeric field that is used for identification.

I think in the programming we failed to follow step 11.
Okay it was very nice of us to program it that even outside bussiness hours the customers would get the move-message, but I guess when we just put saturday and sunday in the move-holiday table we wouldn't have had these problems.

Will see you tomorrow,[morning]

John
 
It says in step 11:

11. The start month, day, hour, and minute must be less than or equal to the end month,day, hour, minute.

In my case, the end date, day, hour and minute are higher then the begin date, day, hour and minute.
It should work fine in my opinion.
 
Hmm... something to investigate when we both are back at the office...
Maybe it takes the starttime for all the days in the period the same, so when you're before the stattime on the next day the rule doesn't apply.[shocked]


Gr33tz,

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top