Hi everyone, well so far so good.. and now i've got a stupid problem that i just cannot seem to get to work...
basicly i want to check Textbox text528 and if the date in there has expired (anything older than today), then it'll notify me.. however weird thing is.. its notifying on dates still 10days to go, and not even notifying of other dates that have expired..
basicly i want to check Textbox text528 and if the date in there has expired (anything older than today), then it'll notify me.. however weird thing is.. its notifying on dates still 10days to go, and not even notifying of other dates that have expired..
Code:
Dim EndDate As Date
EndDate = Text538.Value
If EndDate < Date Then
MsgBox "The Service Plan Has Expired, Please Update ASAP", vbCritical, "SP Has Expired"
Else
End If