将5个工作日添加到开始日期 [英] Adding 5 working days to a start date

问题描述

如果我设置一个带有Date_assigned的任务表和完成任务的天数，我使用下面的代码计算end_date字段我在这个论坛中找到


如何当我输入Date_assigned并更新记录时，在我手动输入DaysToComplete字段中的值之前没有任何反应。我想保持DaysToComplete Constant（5天），所以我尝试在表中设置属性，默认为5，但这不起作用。有什么方法可以让表单计算结束日期而无需在表单中手动输入DaysToComplete值？非常感谢你的帮助

展开 | 选择 | Wrap | 行号

解决方案

所以，你只想要完全忽略Me！NoOfDays字段并在所有情况下使用值5？

如果是这种情况，则需要使用此过程：

展开 | 选择 | 换行 | 行号

< blockquote>

如果是这种情况，那么你需要使用这个程序：

展开 | 选择 | 换行 | 行号

If I set up a task table with an Date_assigned and a number of days to complete the task I calculate the end_date field by using the code below I found in this forum

How ever when I enter the Date_assigned and update the record, nothing happens until I manually enter a value in the DaysToComplete field. I want to keep DaysToComplete Constant (5 Days) so I tried to set the attribute in the table with 5 as the default but this does not work. Is there any way I can get the form to calculate the end date without having to enter the DaysToComplete value manually in the form? Thank you very much for your help

Expand|Select|Wrap|Line Numbers

解决方案

So, you just want to ignore the Me!NoOfDays field completely and use the value 5 in its stead in all situations?

If that is the case then you need to use this procedure :

Expand|Select|Wrap|Line Numbers

If that is the case then you need to use this procedure :

Expand|Select|Wrap|Line Numbers

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