如何在VB.NET中提醒30天的到期日期？ [英] How to alert an expiration date for 30 days in VB.NET?

问题描述

你好。我真的需要帮助我的论文项目。我只想询问当产品已经过期或30天过期时如何提醒或通知。非常感谢您的帮助



Dim strSql as string =选择*来自tblStocks，其中Expiry_Date< = Date（）



感谢您的帮助。



我的尝试：

 Dim strSql as string =select * from tblStocks where Expiry_Date< = Date（）
 
感谢您的帮助。

解决方案

从tblStocks中选择*，其中Expiry_Date< = DATEADD（day，-30，GETDATE（））

Hi guys. I really need help for my Thesis project. I just wanted to ask how to alert or notify when a product has already been expired or 30 days to be expired.? Your help is highly appreciated

Dim strSql as string = "Select * from tblStocks where Expiry_Date <= Date()"

Thank you for the help.

What I have tried:

Dim strSql as string = "Select * from tblStocks where Expiry_Date <= Date()"

Thank you for the help.

解决方案

Select * from tblStocks where Expiry_Date <= DATEADD(day,-30,GETDATE())

这篇关于如何在VB.NET中提醒30天的到期日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！