工作日计算Access 2000 [英] Workdate calculation Access 2000

问题描述

我不是一位经验丰富的程序员。我确实有一个关于

工作日计算的问题。


我有3个字段。 CURDATE，NUMDAYS，CALCDATE


输入前两个字段后，通常是当前日期和

例10（10天期间）我需要CALCDATE到在考虑工作日和假期的情况下，把我的

计算日期转给我。在其他

字，第10个工作日。这是怎么做到的？谢谢你的帮助...


PS。 Reemeber，我没有开始和结束日期，只有开始日期。

解决方案

Hi Pres，

这可能为您做到：
http：//www.mvps .org / access / datetime / date0012.htm


HTH，

Don


" ;介绍，" <豪*** @ optonline.net>在消息中写道

news：57 ************************** @ posting.google.c om ...

我不是一位经验丰富的程序员。我确实有一个关于工作日计算的问题。

我有3个字段。 CURDATE，NUMDAYS，CALCDATE

进入前两个字段后，通常是当前日期和
示例10（10天期间）我需要CALCDATE通过我
计算考虑工作日和假期的日期。用其他的话说，第10个工作日。这是怎么做到的？谢谢你的帮助...

PS。 Reemeber，我没有开始和结束日期，只有开始日期。

我假设我应该使用你提供的网站上列出的第一个功能

我。这是输入代码并链接到特定字段吗？


***通过Devdex发送 http://www.devdex.com ***

不要只是参加USENET ......获得奖励！

是的，我认为第一个功能就是你想要的。

使用说明包含在代码中，我运行了这个小小的

测试，看看它是如何工作的......


来自我的调试窗口（加拿大日是7月1日） ：

？dhAddWorkDaysA（10，Date，＃07/01/2004＃）

7/13/2004


使用你的变量（或控制名称）

dhAddWorkDaysA（NumDays，CurDate，＃& Holidate&＃）


- NumDays = 10

- CurDate = Date（）

- HoliDate（函数要求）= 07/01/2004


结果 - CalcDate = 07/13/2004


Don

----------------------- ------ -


" Pres Holod" <豪*** @ optonline.net>在留言中写道

news：40 ********************** @ news.newsgroups.ws ..


我有3个字段。 CURDATE，NUMDAYS，CALCDATE


输入前两个字段后，通常是当前日期和

例10（10天期间）我需要CALCDATE到在考虑工作日和假期的情况下，把我的

计算日期转给我。在其他

字，第10个工作日。这是怎么做到的？感谢您的帮助...

..

我假设我应该使用您提供的网站上列出的第一个功能
我。这是输入代码并链接到特定字段吗？

***通过Devdex发送 http://www.devdex.com ***
不要只是参加USENET ......获得奖励！

I am not an experienced programmer. I do have a question regarding
workday calculations.

I have 3 fields. CURDATE, NUMDAYS, CALCDATE

After entering the first two fields, normally the current date and for
example 10 (10 day period) I need the CALCDATE to pass me the
calculated date taking into account workdays and holidays. In other
words, the 10th business day. How is this done? Thanks for any help...

PS. Reemeber, I dont have the start and end date, just the start date.

解决方案

Hi Pres,
This might do it for you:
http://www.mvps.org/access/datetime/date0012.htm

HTH,
Don

"Pres" <ho***@optonline.net> wrote in message
news:57**************************@posting.google.c om...

I am not an experienced programmer. I do have a question regarding
workday calculations.

I have 3 fields. CURDATE, NUMDAYS, CALCDATE

After entering the first two fields, normally the current date and for
example 10 (10 day period) I need the CALCDATE to pass me the
calculated date taking into account workdays and holidays. In other
words, the 10th business day. How is this done? Thanks for any help...

PS. Reemeber, I dont have the start and end date, just the start date.

I assume I should use the first function listed on the site you offered
me. Is this typed into the code and linked to the specific fields?

*** Sent via Devdex http://www.devdex.com ***
Don''t just participate in USENET...get rewarded for it!

Hi,

Yes, I think the first function is what you want.
Using the instructions that are included with the code, I ran this little
test to see how this works...

From my Debug Window (Canada Day is July 1st) :
?dhAddWorkDaysA(10,Date,#07/01/2004#)
7/13/2004

Using your variables (or control names)
dhAddWorkDaysA(NumDays,CurDate,# & Holidate & #)

-- NumDays =10
-- CurDate = Date()
-- HoliDate (required by the function) = 07/01/2004

Result -- CalcDate = 07/13/2004

Don
------------------------------

"Pres Holod" <ho***@optonline.net> wrote in message
news:40**********************@news.newsgroups.ws..

I have 3 fields. CURDATE, NUMDAYS, CALCDATE

After entering the first two fields, normally the current date and for
example 10 (10 day period) I need the CALCDATE to pass me the
calculated date taking into account workdays and holidays. In other
words, the 10th business day. How is this done? Thanks for any help...
..

I assume I should use the first function listed on the site you offered
me. Is this typed into the code and linked to the specific fields?

*** Sent via Devdex http://www.devdex.com ***
Don''t just participate in USENET...get rewarded for it!

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