下午 [英] Pm

问题描述

大家好，

我需要计算一个名为7天目标的Access应用程序中提交的日期。此字段将从日期文本（例如，用户输入的07/14/2006）中获取日期值，并在计算工作日数后7天返回日期（例如，07/24/2006）。哦，我还要考虑假期。


海伦


谢谢大家


okosh" AT"提供DOT net


（由主持人更改 - 通过拖网引擎捕获完整的电子邮件地址）

解决方案

您好


Cvdate（[YourField]）+ 7还不行吗？

您好


Cvdate（[YourField]）+ 7还不行吗？

嗨PEB，

感谢您的回复。 +7将是一个常数，但如果在那7天有一些假期，比如3天。所以现在7天将增加到10天。我已经在Excel中处理了这个问题，但Access是一个不同的游戏。不过我会尝试你的建议并让你知道它是如何工作的。

我知道为什么我看不到我的帖子了吗？


Helen

有时发布的文字在这些论坛上消失。

我认为这是软件中的一个错误。

如果是如果你选择它就可以看到它（用鼠标拖动）。

Naff我知道但至少你可以读它。

或者，复制/将它粘贴到其他地方。


日期：

按工作日移动会有点困难。

DateAdd（" w"， 7，YourDate）应该工作（但似乎不是）平日，所以我自己编写。

展开 | 选择 | Wrap | 行号

Hi All,
I need to calculate a date filed in my Access application called ?7 Day Targeted?. This field will take a date value from a date text (say, 07/14/2006, entered by user) and returns a date (say, 07/24/2006) 7days after calculating the number of business days. Oh, I also have to take holidays into consideration.

Helen

Thank you all

okosh "AT" provide "DOT" net

(changed by moderator - full email addresses get picked up by trawling engines for spamming)

解决方案

Hi

Cvdate([YourField])+7 isn''t it enough?

Hi

Cvdate([YourField])+7 isn''t it enough?

Hi PEB,
Thank you for the response. +7 would be a constant, however what if in that 7 days there are some holidays, say 3 days. So now the 7 days will increase to 10 days. I have handled this issue in Excel but Access is a different game. Nevertheless I will try your suggestion and let you know how it works.
Any idea why I can''t see my posting?

Helen

Sometimes the posted text ''disappears'' on these forums.
I think it''s a bug in the software.
If that ever happens, you can see it if you select it (drag over with the mouse).
Naff I know but at least you can read it.
Alternatively, Copy / Paste it elsewhere.

Dates :
Moving by weekday is a little more difficult.
DateAdd("w",7,YourDate) should work (but doesn''t seem to) for weekdays so I wrote my own.

Expand|Select|Wrap|Line Numbers

这篇关于下午的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！