Red Flag warning bsed on Membership date

[RustyRick]

I have (Office 365, Win 10)



tblContacts which has a Membership Anniversary Date.

tblDaily which records the activity of members when they use the facility. It has a Field which records TODAY =NOW()

I need to be flagged if their membership has expired when they step up to LOG IN for the day.

My FORM contains both dates.

What's the best method for that?

[pbaldy]

Depends on your specifics, but along the lines of:

If Me.AnniversaryDate > Date() Then
  MsgBox "Warning, membership expired"
End If

[RustyRick]

Sorry I missed explaining that the Anniversary Date is the DATE of PURCHASE. So the actual Renewal Date would be 365 days later.

[pbaldy]

You can use the DateAdd() function to add a year to the purchase date.

[RustyRick]

Resolved thanks

[pbaldy]

No problem.