如何根据5天的周计算日期 [英] How to calculate dates based on a 5 day week

问题描述

大家好，


我想知道是否可以使用Access 2000自动计算在5天工作周内运行的字段中的日期


提前谢谢

Hi all,

I was wondering if it was possible to use Access 2000 to auto calculate a date in a field operating under a 5 day working week

Thankyou in advance

推荐答案

是的。


给我们提供更多信息，我们可以给你一个通用的答案，但写一些具体的东西要容易得多。给我们一个你想要完成的例子。

Yes.

Give us some more information to work with, we can write you a general answer, but its much easier to write something specific. Give us an example of what you want to accomplish.

谢谢你的时间。


我要做的是创建一个数据库来监控我们所有活动的案例。我的公司每周工作5天（周一到周五），数据库需要反映这一点。例如，一旦我们制定了工作时间表，我们会将其发送给地方议会批准，他们有15天的时间将其返回给我们并发表评论。现在，如果我使用DateAdd只是在发送日期后的15天内添加，那么由于我们只计算工作日，它将会出现错误的日期。

Thankyou for your time.

What i am trying to do is create a database to monitor all our active cases. My company works on a 5 day week (Monday to Friday) and the database needs to reflect that. For example once we have drawn up a schedule of works we send it to the local council for approval and they have 15 days to return it to us with their comments. Now if i use DateAdd to just add 15 days from the date sent it will come up with the wrong date because of our only counting week days.

在这里，我把它扔到了一起你：

Here you go, I threw this together for you:

展开 | 选择 | Wrap | 行号

这篇关于如何根据5天的周计算日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！