添加工作日，工作日计算 [英] add business days, workday calculations

问题描述

我有一个包含这些字段的表格


优先级：紧急关键标准


工作日：1,3,15


提交日期：当前日期


截止日期：


截止日期将根据具体日期计算根据优先级返回许多工作日，例如15/8/08过去15天将返回11/12/08的日期。


i不知道我是什么我正在做，如果有人可以帮助我会非常感激。

i几乎可以做任何事情来尽快完成。


提前谢谢。

i have a form with these fields

Priority level: urgent critical standard

business days: 1, 3, 15

date submitted: current date

due date:

the due date will calculate based on how many business days are returned which is based on priority level, for example 15 days passed 10/22/08 would return a date of 11/12/08.

i have no idea what i am doing, if anyone can help i would greatly appreciate it.
i would do almost anything to get this done asap.


Thank you in advance.

推荐答案

您好


如果您已经在表单上有工作日，那么只需添加一个文本框控件并输入


= DateAdd（" d"，[YourDateControlName]，[YourBusinessDaysControl]）


希望它有所帮助（并且有意义）


问候

Emil

Hi

If you have business days already on the form then just add a text box control and type

=DateAdd("d",[YourDateControlName],[YourBusinessDaysControl])

Hope it helps (and makes sense)

Regards
Emil

工作日很棘手（trixxie）。工作日是算法，但根据定义，工作日必须基于已知数据。

DateAdd（w，5，Date（））应该给出一周的日期。不幸的是，至少到2003版本，这只会增加几天。


如果你感兴趣，我有一个例程来处理这个问题。请务必了解这仅在工作日，而不是工作日进行。

Business days are tricky (trixxie). Weekdays are algorithmic, but business days must, by definition, be based on known data.

DateAdd("w", 5,Date()) should give the date one week hence. Unfortunately, at least up to version 2003, this simply adds days.

If you''re interested, I have a routine to handle this though. Be sure to understand this only deals in week days, NOT business days.

展开 | 选择 | Wrap | 行号

我支持NeoPa所说的：真的没有实际的替代方法来创建一个日期表，每天都有适当的标志设置。您需要记住的另一个因素是假期不是普遍的。大多数都是针对特定国家的，有些甚至是某个国家/地区内的特定区域。


另一种想法：如果您需要在每日工作时间内处理，这些工作时间根据星期几而有所不同，或者会计期间不是基于月份的，你真的别无选择，只能走我建议的路线，在日程表上增加额外的字段以管理所有其他复杂情况。


这种方法可能看起来很多工作，但我的经验是，从长远来看，它确实是唯一有效的方法。

I endorse what NeoPa says: there really is no practical alternative to creating a table of days with a flag set appropriately for each day. Another factor that you need to bear in mind is that holidays are not universal. Most are country specific and some are even region specific within a country.

Another thought: if you ever need to deal in daily working hours which vary according to the day of the week, or accounting periods which are not month based, you really have no choice but to go the route I suggest, with extra fields on the day table to manage all the other complications.

This approach may seem a lot of work, but my experience is that in the long run it''s really the only method that works.

这篇关于添加工作日，工作日计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！