Another Date ? Continued

K

Keypad

Ken Snell,

These are the dates I tried with results. It continues to count for 7 days
after expiration date then stops. Is it possible that after expiration to
have the message say "Membership Expired" until the Void Date is updated with
a new subscription.
Other than that it works perfectly.


5/19/2008 = Expires in 7 days.
5/20/2008 = Expires in 6 days.
5/21/2008 = Expires in 5 days.
5/22/2008 = Expires in 4 days.
5/23/2008 = Expires in 3 days.
5/24/2008 = Expires in 2 days.
5/25/2008 = Expires in 1 day.
5/26/2008 = Membership Expired.
5/27/2008 = Expires in 1 day.
5/28/2008 = Expires in 2 days.
5/29/2008 = Expires in 3 days.
5/30/2008 = Expires in 4 days.
5/31/2008 = Expires in 5 days.
6/1/2008 = Expires in 6 days.
6/2/2008 = Expires in 7 days.
6/3/2008 = No more messages after this date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date calculations in subform 2
Another Date ? 21
administrator account 3
Need a formula 1
Keep unique values 1
Excel PRICE function: How does it compute Issue Date of the Security 5
Date Calculation between Min & Max 1
Countif 3

Top