|
»
»
»
Fwd: Figure payment due date...
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
|
|
|
RE: Figure payment due date...
by VanBuskirk, Patricia
::
Rate this Message:
Hey Tom ... Now it works with moving the paren .. I know I had done that
once, but I am assuming something else was wrong at that point. No problem on the delay ... shortly after my last email, I gave up and decided to take a break from FMP for the rest of the evening! (I really need to get a life) :) Thanks again! Trish -----Original Message----- From: fmpexperts-bounces@... [mailto:fmpexperts-bounces@...] On Behalf Of Tom Elliott Sent: Sunday, July 20, 2008 10:58 PM To: Filemaker Experts Subject: Fwd: Figure payment due date... Trish I 'sent' the following without entering the To address (duh!) - sorry for the delay - hopefully this solves your problem cheers Tom Begin forwarded message: > From: Tom Elliott <thosliot@...> > Date: 20 July 2008 10:28:49 PMBST > Subject: Re: Figure payment due date... > > Trish > > Having looked at it again I think I've maybe found the major bug: > > Date ( Month ( LastPmtDate + 3 ) ; ..... > > should be: > > Date ( Month ( LastPmtDate ) + 3 ; .... > > and the same correction needs to be made in my last message: > > Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year > ( LastPmtDate ) ) > > and > > Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day > ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) > > cheers > > Tom > > On 20 Jul 2008, at 10:14, Tom Elliott wrote: > >> Trish >> >> You don't say how it's not working which makes it a little tricky >> to debug but ... >> >> In the 2nd Case you don't need the complicated Year calc; having >> added 3 months you should just use the year of LastPmtDate and FMP >> will take care of cases where the resulting date is in the >> following year >> >> In other words the result should be: >> >> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >> Year ( LastPmtDate ) ) >> >> Of course that still leaves your "throws off the quarterly >> schedule" dilemma. To solve that you need to know how many payments >> have been made (or *should* have been made) - I guess you can glean >> that from existing data (if not, you need to introduce a new field >> to record this) - so let's say you have a field (PmtCount) that >> gives you this figure, then your result for the 2nd Case would be: >> >> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >> >> (I think) >> >> cheers >> >> Tom >> >> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >> >>> Ah yes, I did change that. For simplicity on the email, I was >>> originally going to change it to a simple if statement without the >>> first >>> statement, then decided to leave it as it was, but I forgot to >>> change >>> that part back. Thanks! >>> >>> -----Original Message----- >>> From: fmpexperts-bounces@... >>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>> Elliott >>> Sent: Sunday, July 20, 2008 4:13 PM >>> To: fmpexperts@... >>> Subject: Re: Figure payment due date... >>> >>> Trish >>> >>> I don't know if it's a typo or not but your first 'If (' should be a >>> 'Case (' >>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>> >>>> I am trying to figure out how to calculate the next payment date, >>>> particularly for recurring bills (hosting). It should be the >>>> same day >>>> every 3 months. This is how I have it, but it is not working. >>>> (FMA9 on >>>> WinXP): >>>> >>>> If ( >>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>> Hosting::CancelDate > Get ( CurrentDate )); >>>> Date ( >>>> Month ( LastPmtDate + 3 ) ; >>>> Day ( Hosting::StartDate ) ; >>>> Year ( >>>> If ( >>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>> )+1 ); ( Get ( CurrentDate ) >>>> ) >>>> ) >>>> ) >>>> ) >>>> ; "") >>>> >>>> ...also, maybe I shouldn't be using the last payment date, as if >>>> they >>>> don't pay on time, that throws off the quarterly schedule. I am >>>> thinking there is a better way. >>>> >>>> Thanks! >>>> Trish >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>> _______________________________________________ >>>> FMPexperts mailing list >>>> FMPexperts@... >>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>> ironclad.net.au >>> >>> _______________________________________________ >>> FMPexperts mailing list >>> FMPexperts@... >>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >>> _______________________________________________ >>> FMPexperts mailing list >>> FMPexperts@... >>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> > _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Figure payment due date...
by Tom Elliott
::
Rate this Message:
Trish
Good - I'm glad it worked out in the end As for getting a life: I re-sent my final message at about 4 am - I couldn't sleep and thought I'd just check my emails ! cheers Tom On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: > Hey Tom ... Now it works with moving the paren .. I know I had done > that > once, but I am assuming something else was wrong at that point. > > No problem on the delay ... shortly after my last email, I gave up and > decided to take a break from FMP for the rest of the evening! (I > really > need to get a life) :) > > Thanks again! > > Trish > > > -----Original Message----- > From: fmpexperts-bounces@... > [mailto:fmpexperts-bounces@...] On Behalf Of Tom > Elliott > Sent: Sunday, July 20, 2008 10:58 PM > To: Filemaker Experts > Subject: Fwd: Figure payment due date... > > Trish > > I 'sent' the following without entering the To address (duh!) - sorry > for the delay - hopefully this solves your problem > > cheers > > Tom > > Begin forwarded message: > >> From: Tom Elliott <thosliot@...> >> Date: 20 July 2008 10:28:49 PMBST >> Subject: Re: Figure payment due date... >> >> Trish >> >> Having looked at it again I think I've maybe found the major bug: >> >> Date ( Month ( LastPmtDate + 3 ) ; ..... >> >> should be: >> >> Date ( Month ( LastPmtDate ) + 3 ; .... >> >> and the same correction needs to be made in my last message: >> >> Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >> ( LastPmtDate ) ) >> >> and >> >> Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >> >> cheers >> >> Tom >> >> On 20 Jul 2008, at 10:14, Tom Elliott wrote: >> >>> Trish >>> >>> You don't say how it's not working which makes it a little tricky >>> to debug but ... >>> >>> In the 2nd Case you don't need the complicated Year calc; having >>> added 3 months you should just use the year of LastPmtDate and FMP >>> will take care of cases where the resulting date is in the >>> following year >>> >>> In other words the result should be: >>> >>> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >>> Year ( LastPmtDate ) ) >>> >>> Of course that still leaves your "throws off the quarterly >>> schedule" dilemma. To solve that you need to know how many payments >>> have been made (or *should* have been made) - I guess you can glean >>> that from existing data (if not, you need to introduce a new field >>> to record this) - so let's say you have a field (PmtCount) that >>> gives you this figure, then your result for the 2nd Case would be: >>> >>> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>> >>> (I think) >>> >>> cheers >>> >>> Tom >>> >>> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >>> >>>> Ah yes, I did change that. For simplicity on the email, I was >>>> originally going to change it to a simple if statement without the >>>> first >>>> statement, then decided to leave it as it was, but I forgot to >>>> change >>>> that part back. Thanks! >>>> >>>> -----Original Message----- >>>> From: fmpexperts-bounces@... >>>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>> Elliott >>>> Sent: Sunday, July 20, 2008 4:13 PM >>>> To: fmpexperts@... >>>> Subject: Re: Figure payment due date... >>>> >>>> Trish >>>> >>>> I don't know if it's a typo or not but your first 'If (' should >>>> be a >>>> 'Case (' >>>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>>> >>>>> I am trying to figure out how to calculate the next payment date, >>>>> particularly for recurring bills (hosting). It should be the >>>>> same day >>>>> every 3 months. This is how I have it, but it is not working. >>>>> (FMA9 on >>>>> WinXP): >>>>> >>>>> If ( >>>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>>> Hosting::CancelDate > Get ( CurrentDate )); >>>>> Date ( >>>>> Month ( LastPmtDate + 3 ) ; >>>>> Day ( Hosting::StartDate ) ; >>>>> Year ( >>>>> If ( >>>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>>> )+1 ); ( Get ( CurrentDate ) >>>>> ) >>>>> ) >>>>> ) >>>>> ) >>>>> ; "") >>>>> >>>>> ...also, maybe I shouldn't be using the last payment date, as if >>>>> they >>>>> don't pay on time, that throws off the quarterly schedule. I am >>>>> thinking there is a better way. >>>>> >>>>> Thanks! >>>>> Trish >>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>> >>>> _______________________________________________ >>>> FMPexperts mailing list >>>> FMPexperts@... >>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>> ironclad.net.au >>>> _______________________________________________ >>>> FMPexperts mailing list >>>> FMPexperts@... >>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>> ironclad.net.au >>> >> > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Figure payment due date...
by VanBuskirk, Patricia
::
Rate this Message:
Tom,
:-D I suppose it's better than some things that one could be doing online! Trish -----Original Message----- From: fmpexperts-bounces@... [mailto:fmpexperts-bounces@...] On Behalf Of Tom Elliott Sent: Monday, July 21, 2008 1:12 PM To: fmpexperts@... Subject: Re: Figure payment due date... Trish Good - I'm glad it worked out in the end As for getting a life: I re-sent my final message at about 4 am - I couldn't sleep and thought I'd just check my emails ! cheers Tom On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: > Hey Tom ... Now it works with moving the paren .. I know I had done > that > once, but I am assuming something else was wrong at that point. > > No problem on the delay ... shortly after my last email, I gave up and > decided to take a break from FMP for the rest of the evening! (I > really > need to get a life) :) > > Thanks again! > > Trish > > > -----Original Message----- > From: fmpexperts-bounces@... > [mailto:fmpexperts-bounces@...] On Behalf Of Tom > Elliott > Sent: Sunday, July 20, 2008 10:58 PM > To: Filemaker Experts > Subject: Fwd: Figure payment due date... > > Trish > > I 'sent' the following without entering the To address (duh!) - sorry > for the delay - hopefully this solves your problem > > cheers > > Tom > > Begin forwarded message: > >> From: Tom Elliott <thosliot@...> >> Date: 20 July 2008 10:28:49 PMBST >> Subject: Re: Figure payment due date... >> >> Trish >> >> Having looked at it again I think I've maybe found the major bug: >> >> Date ( Month ( LastPmtDate + 3 ) ; ..... >> >> should be: >> >> Date ( Month ( LastPmtDate ) + 3 ; .... >> >> and the same correction needs to be made in my last message: >> >> Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >> ( LastPmtDate ) ) >> >> and >> >> Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >> >> cheers >> >> Tom >> >> On 20 Jul 2008, at 10:14, Tom Elliott wrote: >> >>> Trish >>> >>> You don't say how it's not working which makes it a little tricky >>> to debug but ... >>> >>> In the 2nd Case you don't need the complicated Year calc; having >>> added 3 months you should just use the year of LastPmtDate and FMP >>> will take care of cases where the resulting date is in the >>> following year >>> >>> In other words the result should be: >>> >>> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >>> Year ( LastPmtDate ) ) >>> >>> Of course that still leaves your "throws off the quarterly >>> schedule" dilemma. To solve that you need to know how many payments >>> have been made (or *should* have been made) - I guess you can glean >>> that from existing data (if not, you need to introduce a new field >>> to record this) - so let's say you have a field (PmtCount) that >>> gives you this figure, then your result for the 2nd Case would be: >>> >>> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>> >>> (I think) >>> >>> cheers >>> >>> Tom >>> >>> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >>> >>>> Ah yes, I did change that. For simplicity on the email, I was >>>> originally going to change it to a simple if statement without the >>>> first >>>> statement, then decided to leave it as it was, but I forgot to >>>> change >>>> that part back. Thanks! >>>> >>>> -----Original Message----- >>>> From: fmpexperts-bounces@... >>>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>> Elliott >>>> Sent: Sunday, July 20, 2008 4:13 PM >>>> To: fmpexperts@... >>>> Subject: Re: Figure payment due date... >>>> >>>> Trish >>>> >>>> I don't know if it's a typo or not but your first 'If (' should >>>> be a >>>> 'Case (' >>>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>>> >>>>> I am trying to figure out how to calculate the next payment date, >>>>> particularly for recurring bills (hosting). It should be the >>>>> same day >>>>> every 3 months. This is how I have it, but it is not working. >>>>> (FMA9 on >>>>> WinXP): >>>>> >>>>> If ( >>>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>>> Hosting::CancelDate > Get ( CurrentDate )); >>>>> Date ( >>>>> Month ( LastPmtDate + 3 ) ; >>>>> Day ( Hosting::StartDate ) ; >>>>> Year ( >>>>> If ( >>>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>>> )+1 ); ( Get ( CurrentDate ) >>>>> ) >>>>> ) >>>>> ) >>>>> ) >>>>> ; "") >>>>> >>>>> ...also, maybe I shouldn't be using the last payment date, as if >>>>> they >>>>> don't pay on time, that throws off the quarterly schedule. I am >>>>> thinking there is a better way. >>>>> >>>>> Thanks! >>>>> Trish >>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>> >>>> _______________________________________________ >>>> FMPexperts mailing list >>>> FMPexperts@... >>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>> ironclad.net.au >>>> _______________________________________________ >>>> FMPexperts mailing list >>>> FMPexperts@... >>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>> ironclad.net.au >>> >> > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Figure payment due date...
by markv-2
::
Rate this Message:
GETTTTTT MEEEEEEEEEEEEEEE OFFFFFFFFFFFFFFF THISSSSSSSSSSSSSS
DAMNNNNNNNNNNNNNNNNN LISTTTTTTTTTTTTTTTT. WHHHHHHHHHHHHAT DOESSSSSSSSSSSSSSSS IT TAKE TO STOP THIS VanBuskirk, Patricia wrote: > Tom, > > :-D I suppose it's better than some things that one could be doing > online! > > Trish > > > -----Original Message----- > From: fmpexperts-bounces@... > [mailto:fmpexperts-bounces@...] On Behalf Of Tom > Elliott > Sent: Monday, July 21, 2008 1:12 PM > To: fmpexperts@... > Subject: Re: Figure payment due date... > > Trish > > Good - I'm glad it worked out in the end > > As for getting a life: I re-sent my final message at about 4 am - I > couldn't sleep and thought I'd just check my emails ! > > cheers > > Tom > > > On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: > > >> Hey Tom ... Now it works with moving the paren .. I know I had done >> that >> once, but I am assuming something else was wrong at that point. >> >> No problem on the delay ... shortly after my last email, I gave up and >> decided to take a break from FMP for the rest of the evening! (I >> really >> need to get a life) :) >> >> Thanks again! >> >> Trish >> >> >> -----Original Message----- >> From: fmpexperts-bounces@... >> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >> Elliott >> Sent: Sunday, July 20, 2008 10:58 PM >> To: Filemaker Experts >> Subject: Fwd: Figure payment due date... >> >> Trish >> >> I 'sent' the following without entering the To address (duh!) - sorry >> for the delay - hopefully this solves your problem >> >> cheers >> >> Tom >> >> Begin forwarded message: >> >> >>> From: Tom Elliott <thosliot@...> >>> Date: 20 July 2008 10:28:49 PMBST >>> Subject: Re: Figure payment due date... >>> >>> Trish >>> >>> Having looked at it again I think I've maybe found the major bug: >>> >>> Date ( Month ( LastPmtDate + 3 ) ; ..... >>> >>> should be: >>> >>> Date ( Month ( LastPmtDate ) + 3 ; .... >>> >>> and the same correction needs to be made in my last message: >>> >>> Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >>> ( LastPmtDate ) ) >>> >>> and >>> >>> Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>> >>> cheers >>> >>> Tom >>> >>> On 20 Jul 2008, at 10:14, Tom Elliott wrote: >>> >>> >>>> Trish >>>> >>>> You don't say how it's not working which makes it a little tricky >>>> to debug but ... >>>> >>>> In the 2nd Case you don't need the complicated Year calc; having >>>> added 3 months you should just use the year of LastPmtDate and FMP >>>> will take care of cases where the resulting date is in the >>>> following year >>>> >>>> In other words the result should be: >>>> >>>> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >>>> Year ( LastPmtDate ) ) >>>> >>>> Of course that still leaves your "throws off the quarterly >>>> schedule" dilemma. To solve that you need to know how many payments >>>> have been made (or *should* have been made) - I guess you can glean >>>> that from existing data (if not, you need to introduce a new field >>>> to record this) - so let's say you have a field (PmtCount) that >>>> gives you this figure, then your result for the 2nd Case would be: >>>> >>>> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >>>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>>> >>>> (I think) >>>> >>>> cheers >>>> >>>> Tom >>>> >>>> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >>>> >>>> >>>>> Ah yes, I did change that. For simplicity on the email, I was >>>>> originally going to change it to a simple if statement without the >>>>> first >>>>> statement, then decided to leave it as it was, but I forgot to >>>>> change >>>>> that part back. Thanks! >>>>> >>>>> -----Original Message----- >>>>> From: fmpexperts-bounces@... >>>>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>>> Elliott >>>>> Sent: Sunday, July 20, 2008 4:13 PM >>>>> To: fmpexperts@... >>>>> Subject: Re: Figure payment due date... >>>>> >>>>> Trish >>>>> >>>>> I don't know if it's a typo or not but your first 'If (' should >>>>> be a >>>>> 'Case (' >>>>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>>>> >>>>> >>>>>> I am trying to figure out how to calculate the next payment date, >>>>>> particularly for recurring bills (hosting). It should be the >>>>>> same day >>>>>> every 3 months. This is how I have it, but it is not working. >>>>>> (FMA9 on >>>>>> WinXP): >>>>>> >>>>>> If ( >>>>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>>>> Hosting::CancelDate > Get ( CurrentDate )); >>>>>> Date ( >>>>>> Month ( LastPmtDate + 3 ) ; >>>>>> Day ( Hosting::StartDate ) ; >>>>>> Year ( >>>>>> If ( >>>>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>>>> )+1 ); ( Get ( CurrentDate ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ; "") >>>>>> >>>>>> ...also, maybe I shouldn't be using the last payment date, as if >>>>>> they >>>>>> don't pay on time, that throws off the quarterly schedule. I am >>>>>> thinking there is a better way. >>>>>> >>>>>> Thanks! >>>>>> Trish >>>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>>> _______________________________________________ >>>>>> FMPexperts mailing list >>>>>> FMPexperts@... >>>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>>> ironclad.net.au >>>>>> >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>>> >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > > _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Figure payment due date...
by markv-2
::
Rate this Message:
IF I POST SPAM< TO THIS LIST WILL I FINALLY GET REMOVED ? IF THATS WHAT
IT TAKES Tom Elliott wrote: > Trish > > Good - I'm glad it worked out in the end > > As for getting a life: I re-sent my final message at about 4 am - I > couldn't sleep and thought I'd just check my emails ! > > cheers > > Tom > > > On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: > >> Hey Tom ... Now it works with moving the paren .. I know I had done that >> once, but I am assuming something else was wrong at that point. >> >> No problem on the delay ... shortly after my last email, I gave up and >> decided to take a break from FMP for the rest of the evening! (I really >> need to get a life) :) >> >> Thanks again! >> >> Trish >> >> >> -----Original Message----- >> From: fmpexperts-bounces@... >> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >> Elliott >> Sent: Sunday, July 20, 2008 10:58 PM >> To: Filemaker Experts >> Subject: Fwd: Figure payment due date... >> >> Trish >> >> I 'sent' the following without entering the To address (duh!) - sorry >> for the delay - hopefully this solves your problem >> >> cheers >> >> Tom >> >> Begin forwarded message: >> >>> From: Tom Elliott <thosliot@...> >>> Date: 20 July 2008 10:28:49 PMBST >>> Subject: Re: Figure payment due date... >>> >>> Trish >>> >>> Having looked at it again I think I've maybe found the major bug: >>> >>> Date ( Month ( LastPmtDate + 3 ) ; ..... >>> >>> should be: >>> >>> Date ( Month ( LastPmtDate ) + 3 ; .... >>> >>> and the same correction needs to be made in my last message: >>> >>> Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >>> ( LastPmtDate ) ) >>> >>> and >>> >>> Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>> >>> cheers >>> >>> Tom >>> >>> On 20 Jul 2008, at 10:14, Tom Elliott wrote: >>> >>>> Trish >>>> >>>> You don't say how it's not working which makes it a little tricky >>>> to debug but ... >>>> >>>> In the 2nd Case you don't need the complicated Year calc; having >>>> added 3 months you should just use the year of LastPmtDate and FMP >>>> will take care of cases where the resulting date is in the >>>> following year >>>> >>>> In other words the result should be: >>>> >>>> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >>>> Year ( LastPmtDate ) ) >>>> >>>> Of course that still leaves your "throws off the quarterly >>>> schedule" dilemma. To solve that you need to know how many payments >>>> have been made (or *should* have been made) - I guess you can glean >>>> that from existing data (if not, you need to introduce a new field >>>> to record this) - so let's say you have a field (PmtCount) that >>>> gives you this figure, then your result for the 2nd Case would be: >>>> >>>> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >>>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>>> >>>> (I think) >>>> >>>> cheers >>>> >>>> Tom >>>> >>>> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >>>> >>>>> Ah yes, I did change that. For simplicity on the email, I was >>>>> originally going to change it to a simple if statement without the >>>>> first >>>>> statement, then decided to leave it as it was, but I forgot to >>>>> change >>>>> that part back. Thanks! >>>>> >>>>> -----Original Message----- >>>>> From: fmpexperts-bounces@... >>>>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>>> Elliott >>>>> Sent: Sunday, July 20, 2008 4:13 PM >>>>> To: fmpexperts@... >>>>> Subject: Re: Figure payment due date... >>>>> >>>>> Trish >>>>> >>>>> I don't know if it's a typo or not but your first 'If (' should be a >>>>> 'Case (' >>>>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>>>> >>>>>> I am trying to figure out how to calculate the next payment date, >>>>>> particularly for recurring bills (hosting). It should be the >>>>>> same day >>>>>> every 3 months. This is how I have it, but it is not working. >>>>>> (FMA9 on >>>>>> WinXP): >>>>>> >>>>>> If ( >>>>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>>>> Hosting::CancelDate > Get ( CurrentDate )); >>>>>> Date ( >>>>>> Month ( LastPmtDate + 3 ) ; >>>>>> Day ( Hosting::StartDate ) ; >>>>>> Year ( >>>>>> If ( >>>>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>>>> )+1 ); ( Get ( CurrentDate ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ; "") >>>>>> >>>>>> ...also, maybe I shouldn't be using the last payment date, as if >>>>>> they >>>>>> don't pay on time, that throws off the quarterly schedule. I am >>>>>> thinking there is a better way. >>>>>> >>>>>> Thanks! >>>>>> Trish >>>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>>> _______________________________________________ >>>>>> FMPexperts mailing list >>>>>> FMPexperts@... >>>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>>> ironclad.net.au >>>>> >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >>>> >>> >> >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Figure payment due date...
by VanBuskirk, Patricia
::
Rate this Message:
I am very sorry ... I realized after I already hit send I was sending to
the list and not directly to Tom. Just having some innocent fun. I do apologize though! -----Original Message----- From: fmpexperts-bounces@... [mailto:fmpexperts-bounces@...] On Behalf Of markv@... Sent: Monday, July 21, 2008 1:30 PM To: fmpexperts@... Subject: Re: Figure payment due date... GETTTTTT MEEEEEEEEEEEEEEE OFFFFFFFFFFFFFFF THISSSSSSSSSSSSSS DAMNNNNNNNNNNNNNNNNN LISTTTTTTTTTTTTTTTT. WHHHHHHHHHHHHAT DOESSSSSSSSSSSSSSSS IT TAKE TO STOP THIS VanBuskirk, Patricia wrote: > Tom, > > :-D I suppose it's better than some things that one could be doing > online! > > Trish > > > -----Original Message----- > From: fmpexperts-bounces@... > [mailto:fmpexperts-bounces@...] On Behalf Of Tom > Elliott > Sent: Monday, July 21, 2008 1:12 PM > To: fmpexperts@... > Subject: Re: Figure payment due date... > > Trish > > Good - I'm glad it worked out in the end > > As for getting a life: I re-sent my final message at about 4 am - I > couldn't sleep and thought I'd just check my emails ! > > cheers > > Tom > > > On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: > > >> Hey Tom ... Now it works with moving the paren .. I know I had done >> that >> once, but I am assuming something else was wrong at that point. >> >> No problem on the delay ... shortly after my last email, I gave up >> decided to take a break from FMP for the rest of the evening! (I >> really >> need to get a life) :) >> >> Thanks again! >> >> Trish >> >> >> -----Original Message----- >> From: fmpexperts-bounces@... >> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >> Elliott >> Sent: Sunday, July 20, 2008 10:58 PM >> To: Filemaker Experts >> Subject: Fwd: Figure payment due date... >> >> Trish >> >> I 'sent' the following without entering the To address (duh!) - sorry >> for the delay - hopefully this solves your problem >> >> cheers >> >> Tom >> >> Begin forwarded message: >> >> >>> From: Tom Elliott <thosliot@...> >>> Date: 20 July 2008 10:28:49 PMBST >>> Subject: Re: Figure payment due date... >>> >>> Trish >>> >>> Having looked at it again I think I've maybe found the major bug: >>> >>> Date ( Month ( LastPmtDate + 3 ) ; ..... >>> >>> should be: >>> >>> Date ( Month ( LastPmtDate ) + 3 ; .... >>> >>> and the same correction needs to be made in my last message: >>> >>> Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >>> ( LastPmtDate ) ) >>> >>> and >>> >>> Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>> >>> cheers >>> >>> Tom >>> >>> On 20 Jul 2008, at 10:14, Tom Elliott wrote: >>> >>> >>>> Trish >>>> >>>> You don't say how it's not working which makes it a little tricky >>>> to debug but ... >>>> >>>> In the 2nd Case you don't need the complicated Year calc; having >>>> added 3 months you should just use the year of LastPmtDate and FMP >>>> will take care of cases where the resulting date is in the >>>> following year >>>> >>>> In other words the result should be: >>>> >>>> Date ( Month ( LastPmtDate + 3 ) ; Day ( Hosting::StartDate ) ; >>>> Year ( LastPmtDate ) ) >>>> >>>> Of course that still leaves your "throws off the quarterly >>>> schedule" dilemma. To solve that you need to know how many payments >>>> have been made (or *should* have been made) - I guess you can glean >>>> that from existing data (if not, you need to introduce a new field >>>> to record this) - so let's say you have a field (PmtCount) that >>>> gives you this figure, then your result for the 2nd Case would be: >>>> >>>> Date ( Month ( LastPmtDate + 3 * PmtCount ) ; Day >>>> ( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>>> >>>> (I think) >>>> >>>> cheers >>>> >>>> Tom >>>> >>>> On 20 Jul 2008, at 9:23, VanBuskirk, Patricia wrote: >>>> >>>> >>>>> Ah yes, I did change that. For simplicity on the email, I was >>>>> originally going to change it to a simple if statement without the >>>>> first >>>>> statement, then decided to leave it as it was, but I forgot to >>>>> change >>>>> that part back. Thanks! >>>>> >>>>> -----Original Message----- >>>>> From: fmpexperts-bounces@... >>>>> [mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>>> Elliott >>>>> Sent: Sunday, July 20, 2008 4:13 PM >>>>> To: fmpexperts@... >>>>> Subject: Re: Figure payment due date... >>>>> >>>>> Trish >>>>> >>>>> I don't know if it's a typo or not but your first 'If (' should >>>>> be a >>>>> 'Case (' >>>>> On 20 Jul 2008, at 9:09, VanBuskirk, Patricia wrote: >>>>> >>>>> >>>>>> I am trying to figure out how to calculate the next payment date, >>>>>> particularly for recurring bills (hosting). It should be the >>>>>> same day >>>>>> every 3 months. This is how I have it, but it is not working. >>>>>> (FMA9 on >>>>>> WinXP): >>>>>> >>>>>> If ( >>>>>> RecurringBill = "No" and BalanceDue > 0; LastPmtDate + 30; >>>>>> RecurringBill = "Yes" and (IsEmpty ( Hosting::CancelDate ) or >>>>>> Hosting::CancelDate > Get ( CurrentDate )); >>>>>> Date ( >>>>>> Month ( LastPmtDate + 3 ) ; >>>>>> Day ( Hosting::StartDate ) ; >>>>>> Year ( >>>>>> If ( >>>>>> Month ( Get ( CurrentDate ) ) = 12; ( Get ( CurrentDate >>>>>> )+1 ); ( Get ( CurrentDate ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ) >>>>>> ; "") >>>>>> >>>>>> ...also, maybe I shouldn't be using the last payment date, as if >>>>>> they >>>>>> don't pay on time, that throws off the quarterly schedule. I am >>>>>> thinking there is a better way. >>>>>> >>>>>> Thanks! >>>>>> Trish >>>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>>> _______________________________________________ >>>>>> FMPexperts mailing list >>>>>> FMPexperts@... >>>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>>> ironclad.net.au >>>>>> >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>>> _______________________________________________ >>>>> FMPexperts mailing list >>>>> FMPexperts@... >>>>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts- >>>>> ironclad.net.au >>>>> >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > > _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Figure payment due date...
by Audrey Akhavan
::
Rate this Message:
Heloo Mark, Click on the link below and UNSUBSCRIBE YOURSELF (scroll to the lower part of the page): http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au Audrey At 10:30 AM 7/21/2008, markv@... wrote: >GETTTTTT MEEEEEEEEEEEEEEE OFFFFFFFFFFFFFFF THISSSSSSSSSSSSSS >DAMNNNNNNNNNNNNNNNNN LISTTTTTTTTTTTTTTTT. WHHHHHHHHHHHHAT >DOESSSSSSSSSSSSSSSS IT TAKE TO STOP THIS > > >VanBuskirk, Patricia wrote: >>Tom, >> >>:-D I suppose it's better than some things that one could be doing >>online! >> >>Trish >> >> >>-----Original Message----- >>From: fmpexperts-bounces@... >>[mailto:fmpexperts-bounces@...] On Behalf Of Tom >>Elliott >>Sent: Monday, July 21, 2008 1:12 PM >>To: fmpexperts@... >>Subject: Re: Figure payment due date... >> >>Trish >> >>Good - I'm glad it worked out in the end >> >>As for getting a life: I re-sent my final message at about 4 am - I >>couldn't sleep and thought I'd just check my emails ! >> >>cheers >> >>Tom >> >> >>On 21 Jul 2008, at 12:50, VanBuskirk, Patricia wrote: >> >> >>>Hey Tom ... Now it works with moving the paren .. I know I had done >>>that >>>once, but I am assuming something else was wrong at that point. >>> >>>No problem on the delay ... shortly after my last email, I gave up and >>>decided to take a break from FMP for the rest of the evening! (I >>>really >>>need to get a life) :) >>> >>>Thanks again! >>> >>>Trish >>> >>> >>>-----Original Message----- >>>From: fmpexperts-bounces@... >>>[mailto:fmpexperts-bounces@...] On Behalf Of Tom >>>Elliott >>>Sent: Sunday, July 20, 2008 10:58 PM >>>To: Filemaker Experts >>>Subject: Fwd: Figure payment due date... >>> >>>Trish >>> >>>I 'sent' the following without entering the To address (duh!) - sorry >>>for the delay - hopefully this solves your problem >>> >>>cheers >>> >>>Tom >>> >>>Begin forwarded message: >>> >>> >>>>From: Tom Elliott <thosliot@...> >>>>Date: 20 July 2008 10:28:49 PMBST >>>>Subject: Re: Figure payment due date... >>>> >>>>Trish >>>> >>>>Having looked at it again I think I've maybe found the major bug: >>>> >>>>Date ( Month ( LastPmtDate + 3 ) ; ..... >>>> >>>>should be: >>>> >>>>Date ( Month ( LastPmtDate ) + 3 ; .... >>>> >>>>and the same correction needs to be made in my last message: >>>> >>>>Date ( Month ( LastPmtDate ) ; Day ( Hosting::StartDate ) ; Year >>>>( LastPmtDate ) ) >>>> >>>>and >>>> >>>>Date ( Month ( LastPmtDate ) + 3 * PmtCount ; Day >>>>( Hosting::StartDate ) ; Year ( LastPmtDate ) ) >>>> >>>>cheers >>>> >>>>Tom >>>> >> |
