Problems with Date Formula

[mikajake]

I have a VIP Database that stores all of our customer VIP's. We just started a new promotion that puts new customers on the VIP list for only 6 Months. I use the creation date as the date they were added. I can't figure out how to get and accurate or close to accurate expiration date for that customer.

Any help would be greatly appreciated.

 

[tonyA1DL]

Create a status field as a calculated field dependent on another keyed date field.

We use the formula below to flag up whether electrical safety tests are current returns blank, retest due, expired or awaiting first test.

I'm sure you can easily modify this formula to achieve what you need.


If(PAT_TEST < Today() - 365, If(PAT_TEST = '', 'Awaiting first test', 'Expired'), If(PAT_TEST < Today() - 337, 'Retest Due', ''))