I posted earlier about a pop up that would remind the users about when a participant is due to renew their application. This what I got so far. Not sure if this is correct though. Can anyone help please. I have SQL as the engine and
Access 2007 as the Gui.
CREATE PROCEDURE ReferralReminder
DECLARE @ReferralDate datetime = '20100401'
IF DateAdd(mm, @ReferralDate, 3) < GetDate()
PRINT 'Time to renew'
PRINT 'Nope, we''re still good without a renewal'
SELECT FirstName, LastName, ReferralDate
View Complete Post