calculation field for upcoming dates

[thompm65]

Hello,

I am working on a membership database and would like to create a field that shows memberships expiring within the next two months (Feb and March). I have an expiration data field formatted as date/yr. How do I make a field that shows the expiration date plus 2 months?

Thanks, MT

[Lee Smith]

If this is a Date Field, formatted to show just the year, then all you need to do is to use 60 days as I did in the calculation below. If it isn't a real date field, let me know.

There are a couple of ways to do this. You can make the date itself change color, you can

create a flag field, or you can have a graphic show.

For the basic Flag, your calculation would look like this:

Case ( Get ( CurrentDate ) + 60 ≥ expiration_date ; "Flag")

HTH

Lee

[thompm65]

Hi,

Actually the expiration date field is a calculation

(Last paid + 365)

So using this month as an example (January) I would like to list only the members whose membership is expiring in March.

Thanks, MT