提醒行动结束日期逾期(5天) [英] Reminder for Action Closure Date Overdue (5 Days)
问题描述
大家好,
我有3列:
行动开始日期,计划关闭日期&我的应用程序中的真实关闭日期名为Employee Actions Manager,使用VB.Net2010& MS Access 2010.
我想设置一个提醒,可以在计划关闭日期后的第5天提醒我每个操作。
当我打开我的应用程序时,我想要一个提醒,我有数据网格中的所有记录...我可以突出显示记录作为提示吗???
我已经在名称(FillByPositive5DaysDelay)下的Action Log Table Adapter中添加了一个查询,如下所示:
Hi guys,
I have 3 columns:
Action Start Date, Planned Closure Date & Real Closure Date in my application called Employee Actions Manager developed by using VB.Net2010 & MS Access 2010.
I want to set a reminder that can remind me on 5th day after the Planned Closure Date for each action.
I want a reminder when I open my Application, I have all the records in data grid...can I highlight the record as a reminder???
What I already did added a query in the Action Log Table Adaptor under name (FillByPositive5DaysDelay) which is as follows:
SELECT ID, ActionReferance, ActionDescription, ActionSite, ActionCategory, ActionImportance, ActionAccountability, ActionProgressStatus, ActionClosurestatus, ActionDoneBy,
ActionComment, ActionYear, ActionStartDate, PlannedClosureDate, RealClosureDate
FROM ActionsLog
WHERE (PlannedClosureDate >= DATEADD(DD, + 5, GETDATE()))
但是有一个SQL执行错误(表达式中未定义的函数GETDATE)。所以你可以帮我避免这个错误r?
请注意我在操作日志表单中添加了以下功能,但同样的问题仍然存在。
But there is a SQL execution error (undefined function GETDATE in expression).So can you help me to avoid this error?
Please kindly note that I have added the following function in the Actions Log form but the same problem still persists.
Private Sub GETDATE()
System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")
End Sub
在此先感谢!!
Thanks in advance!!
推荐答案
Microsoft Access不知道GETDATE()是什么。您可以在Access中使用NOW()。
Microsoft Access does not know what GETDATE() is. You can use NOW() in Access.
正确的WHERE
子句应如下所示:
A properWHERE
clause should look like:
WHERE (PlannedClosureDate >= DATEADD("d", 5, DATE()))
详情请见:
日期功能(MS Access) [ ^ ]
DATEADD函数(MS Access) [ ^ ]
这篇关于提醒行动结束日期逾期(5天)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!