Re: Expiration Date Calculation
- From: "Sawaddi" <joettedenny@xxxxxxxxxxxxx>
- Date: 26 Mar 2007 02:02:39 -0700
Thanks so much for explaining what the parts of the calculation mean.
Seems I am not making myself clear enough, though.
I currently use a calculation field that gives me the one-year
expiration. What I need to do is
1) have the calculation give me 1/31/2008 expiry date for any DatePAID
since 2/1/2007
AND at the same time
2) have the calculation keep the current members expiration dates
until they renew later this year - through 1/31/2008
Hence, I think I need a case statement so that the members whose
expiration dates haven't yet occurred will continue to show (ie, as
one year from last July, for example). Maybe I'm making it harder than
it needs to be?
We are changing our annual dues payment from rolling to one-time
renewal with everyone's expiration date at end Jan. This is the
transition year and I don't know how to change my calculation field.
Does that help?
VoicesInMyHead wrote:
On Mar 25, 6:44 pm, "Sawaddi" <joettede...@xxxxxxxxxxxxx> wrote:
Thanks, Grip.
I realize the second case statement doesn't work. That's why I wrote. :
(
What I need is to have something in the field calculation that will
calculate any DatePAID with date before 2/1/2007 to show one year
later, end of the month.
I'm not using an auto-enter calc. It's a field calculation for
DateEXPIRES.
Can you suggest what I should use as the second part of the case
statement? I'm not well versed in calculations, but I do learn
quickly.
The "Do Not Evaluate if Referenced Fields are Empty" box is ticked. I
don't see a "Do not
replace existing value" option in FMP 7.
If you are changing or adding a new expiration Calc field that is a
Date result, the calculation you are looking for is:
Date(Month(DatePAID) ; 0 ; Year(DatePAID) + 1)
The "Date" function is Date(Month ; Day ; Year), so in your case it's
like this:
Month = DatePAID month
Day = 0
Year = DatePAID year +1
Zero comes before 1, so in FileMaker, the 0 in the date function is
the day before the 1st, which is how the month changes as well.
You shouldn't need an IF or CASE if I am reading what you are looking
for correctly. No matter what the date is (past or present), the
above calc will give you a 1 year expiration. I made a quick example
file you can look at:
http://members.cox.net/voicesinmyhead/fmp/datepaid.fp7
Good luck!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Reality is the leading cause of stress...
...amongst those in touch with it.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
WinXP Pro 64Bit / FMP Adv 8.5v1
VoicesInMyHead
a.k.a. The Voices
No, we're not... Yes, we are...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
.
- Follow-Ups:
- Re: Expiration Date Calculation
- From: VoicesInMyHead
- Re: Expiration Date Calculation
- References:
- Expiration Date Calculation
- From: Sawaddi
- Re: Expiration Date Calculation
- From: Grip
- Re: Expiration Date Calculation
- From: Sawaddi
- Re: Expiration Date Calculation
- From: VoicesInMyHead
- Expiration Date Calculation
- Prev by Date: Re: linking images
- Next by Date: Re: Some questions on xmCHART
- Previous by thread: Re: Expiration Date Calculation
- Next by thread: Re: Expiration Date Calculation
- Index(es):
Relevant Pages
|
|
