计算工作日的功能 [英] Function to count workdays

查看:99
本文介绍了计算工作日的功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个名为modWorkdayFunctions的A97模块:

http://www.oakland.edu/~fortune/WorkdayFunctions.zip


它允许计算工作日,考虑到最多11个工作日>
美国假期。可以轻松添加更多假期。此外,还有一个

布尔标志,用于包括或排除星期六或星期日作为工作周的一部分

。我所知道的唯一遗漏的是,周五或周一会有一些

假期,如果它们周末落在了
周末。这些功能尚未考虑到这一点。


样本strFlag =" 11111111111" - 1 =检查那个假期,0 =不要

查看


James A. Fortune

解决方案

2005年8月10日16:41:38 -0700, ji * *******@compumarc.com 写道:

我有一个名为modWorkdayFunctions的A97模块:



[snip]


将业务数据存储在表格中,而不是代码中。


mi ** @ sherrillshelton.net 写道:

2005年8月10日16:41:38 -0700, ji ******** @ compumarc.com 写道:

我有一个A97名为modWorkdayFunctions的模块:


[snip]

将业务数据存储在表中,而不是代码中。




我到目前为止看到的代码(来自Getz等人)使用代码加上假期

表。我正在摆脱假期表。如果您宁愿

维持该表,请成为我的客人。或者你指的是什么?

其他?


James A. Fortune


路易斯安那州时购买,交易到英格兰占据了b $ b美国约75%的贸易和贸易对法国占约25%的美元贸易 - 杰斐逊的开局


ji ******** @compumarc .com 写在

新闻:11 ********************* @ g14g2000cwa.googlegro ups.com:

mi**@sherrillshelton.net 写道:

存储业务数据在表格中,而不是在代码中。



我到目前为止看到的代码(来自Getz等人)使用代码加上
假期表。我正在摆脱假期餐桌。
如果你宁愿保养那张桌子,那就做我的客人吧。或者你是否指的是其他东西?



您希望最终用户维护代码还是表格?

假期可以改变,某些司法管辖区有额外的假期
来自其他司法管辖区的b $ b。改变一个表格是微不足道的,但是在分布式的.mde中不是很简单。


或者这是对工作安全的尝试吗? />

-

Bob Quintal


PA是我改变了我的电子邮件地址。


I have an A97 module called modWorkdayFunctions in:

http://www.oakland.edu/~fortune/WorkdayFunctions.zip

It allows the counting of workdays taking into consideration up to 11
U.S. holidays. More holidays can be added easily. Also, there is a
boolean flag for including or excluding Saturdays or Sundays as part of
the work week. The only thing I know of that is missing is that some
holidays are observed on a Friday or a Monday if they fall on a
weekend. These functions do not account for that yet.

Sample strFlag = "11111111111" -- 1 = check that holiday, 0 = don''t
check

James A. Fortune

解决方案

On 10 Aug 2005 16:41:38 -0700, ji********@compumarc.com wrote:

I have an A97 module called modWorkdayFunctions in:


[snip]

Store business data in tables, not in code.


mi**@sherrillshelton.net wrote:

On 10 Aug 2005 16:41:38 -0700, ji********@compumarc.com wrote:

I have an A97 module called modWorkdayFunctions in:


[snip]

Store business data in tables, not in code.



The code I''ve seen so far (from Getz, et. al.) uses code plus a holiday
table. I''m just getting rid of the holiday table. If you''d rather
maintain that table, be my guest. Or are you referring to something
else?

James A. Fortune

At the time of the Louisiana Purchase, trade to England accounted for
about 75% of U.S. trade and trade to France accounted for about 25% of
U.S. Trade -- Jefferson''s Gambit


ji********@compumarc.com wrote in
news:11*********************@g14g2000cwa.googlegro ups.com:

mi**@sherrillshelton.net wrote:

Store business data in tables, not in code.



The code I''ve seen so far (from Getz, et. al.) uses code plus
a holiday table. I''m just getting rid of the holiday table.
If you''d rather maintain that table, be my guest. Or are you
referring to something else?


Would you prefer the end users to maintain the code or a table?
Holidays can change and some jurisdictions have additional holidays
from other jurisdictions. It is trivial to alter a table, but not
trivial in a distributed .mde for example.

Or is this an attempt at job security?

--
Bob Quintal

PA is y I''ve altered my email address.


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

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆