提醒行动结束日期逾期（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 proper WHERE clause should look like:

WHERE (PlannedClosureDate >= DATEADD("d", 5, DATE()))

详情请见：

日期功能（MS Access） [ ^ ]

DATEADD函数（MS Access） [ ^ ]

这篇关于提醒行动结束日期逾期（5天）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！