日期和假期。我需要指导 [英] Dates and Holidays. I need direction
问题描述
再次回来，渴望知识。 :)
http：//www.thescripts .com / forum / show ... 76＃post2314976
是我的最后一个帖子。我仍然在做同一个项目，但是在另一个阶段。
我现在有了我的表格，减去了休假日期和返回日期。然后将结果发送到我的DaysGone。框，然后将其值乘以8（工作日中的8小时），然后发送到HoursGone。第一步是让它全部运转起来，现在效果很好，感谢社区的帮助，主要是玛丽。
我现在的问题是，我怎么在周末算出来？并且可能是假期。
即一名员工在周三离开并返回随后的周三，他将失踪7天。但是，由于周末不计算，员工只错过了5天的工作。
我不希望任何人交给我代码（虽然这会有所帮助;））如果有是一个开始研究这个的好地方，只是指出我正确的方向，就是我所要求的。
谢谢
Back again, thirsting for knowlege. :)
http://www.thescripts.com/forum/show...76#post2314976
Was my last thread. I am still working on the same project, but a different stage.
I now have my form, subtracting the leave date, and return date. The result is then sent to my "DaysGone" box and then its value is multiplied by 8 (8 hours in a workday) and then send to "HoursGone" The first step was getting it all to work, and it works great now, thanks to help from the community, mainly Mary.
My Question now, is How do I figure in weekends? And Possibly Holidays.
i.e. A employee leaves on wednesday and returns the followoing wednesday, he would be missing 7 days. However, since weekends do not count, the employee has only missed 5 days of work.
I am not expecting anyone to hand me the code (though it would help ;) ) If there is a good place to start researching this, just point me in the right direction, is all I ask.
Thank you
推荐答案
再次回来，渴望知识。 :)
http：//www.thescripts .com / forum / show ... 76＃post2314976
是我的最后一个帖子。我仍然在做同一个项目，但是在另一个阶段。
我现在有了我的表格，减去了休假日期和返回日期。然后将结果发送到我的DaysGone。框，然后将其值乘以8（工作日中的8小时），然后发送到HoursGone。第一步是让它全部运转起来，现在效果很好，感谢社区的帮助，主要是玛丽。
我现在的问题是，我怎么在周末算出来？并且可能是假期。
即一名员工在周三离开并返回随后的周三，他将失踪7天。但是，由于周末不计算，员工只错过了5天的工作。
我不希望任何人交给我代码（虽然这会有所帮助;））如果有是一个开始研究这个问题的好地方，只需指出正确的方向，就是我所要求的。
谢谢
Back again, thirsting for knowlege. :)
http://www.thescripts.com/forum/show...76#post2314976
Was my last thread. I am still working on the same project, but a different stage.
I now have my form, subtracting the leave date, and return date. The result is then sent to my "DaysGone" box and then its value is multiplied by 8 (8 hours in a workday) and then send to "HoursGone" The first step was getting it all to work, and it works great now, thanks to help from the community, mainly Mary.
My Question now, is How do I figure in weekends? And Possibly Holidays.
i.e. A employee leaves on wednesday and returns the followoing wednesday, he would be missing 7 days. However, since weekends do not count, the employee has only missed 5 days of work.
I am not expecting anyone to hand me the code (though it would help ;) ) If there is a good place to start researching this, just point me in the right direction, is all I ask.
Thank you
只是填写更多解释：
假期是一些经常被问到的问题，很明显很容易。 有些需要被解雇！这是一个非常复杂的领域，因为它不太适合RDBMS的概念。 TSDN中有一些线程可以更详细地解决这个问题并解决问题（主要是），但它们很难完成并需要额外的维护。
另一个类似的难题 some
Just to fill in with some more explanation :
Holidays is one of those often asked questions that seem to some, to be obviously very easy. Some need to be disabused! It is a very complicated area as it does not fit very well into the concepts of an RDBMS. There are threads in TSDN which go into this in more detail and do resolve the issue (mostly), but they are hard work and require extra maintenance.
Another similarly tough question that some feel should be very easy, is numbering lines returned from a query. Again, there are threads that explain how, but unless you have a hardy constitution, you don''t want to go there.
这篇关于日期和假期。我需要指导的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
