Caught the bug, You did a visibly small mistake with the begins and ends while modifying the code
which botched up the whole thing.
Every “begin” should have its “end” in the proper place. This is a simple rule with each and
everything in this universe I believe.
I tested and found that is the only snag. Correct this and this will work. I have modified and writen my
comments in the attachment.
Check these two lines in the attachment.
--end (You have put this “end” wrongly here. And you are missing one ‘END’ which corresponds to the ‘BEGIN’ above which should be just before the line ‘return @CalcHours’)
END – You were missing this END here
Also I have a piece of advice. When you are doing programming (even if the original writer is someone else
and you are modifying it) you must pay your fullest attention. No doubt it is time consuming but this is all
about programming sadly.
I believe you are smart enough ;), possibly you just did not pay attention just because you are the boss:w00t:
there. Have a nice time.
Sincerely,
Maz
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]