Re: billing system
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52801
interpreted = N
texte = I noticed this is what Rob said but i offered a little code :) ----- Original Message ----- From: "WebDna @"
To: "WebDNA Talk" Sent: Thursday, September 11, 2003 3:09 PM Subject: Re: billing system > It seems to me that all you need to do is take the number of days in the > month and compare it to the billing day of the account. > > [!]How many days are in the month -- seems to work for leap year[/!] > [math > show=f]num_of_days=({[the_month]/1/[the_year]}+{1/0/0000})-{[the_month]/1/[t > he_year]}[/math] > > Now either store the day they are billed on or strip it out some how. (for > this example we will use 31st) > > [math show=f]billday=31[/math] > > [if (([billday]>[num_of_days]) & ([num_of_days]=[date %d]))] > [then] > bill now > [/then] > [else] > normal billing cycle > [/else] > [/if] > > The above should look and see 28 days in feb (29 in those leap years) and > the 30th in those months that only have 30. > > You would need to tell the client that they are being billed once a month, > not on the same day every month. > > RonnyMc > > > > > > > ----- Original Message ----- > From: "Kalin Mintchev" > To: "WebDNA Talk" > Sent: Thursday, September 11, 2003 2:00 PM > Subject: Re: billing system > > > > > > i think we offered them a formula that whoever subscribes after 28 if any > > given month his/hers next date bill will be on the the 1st day of the > > month after the next.... > > > > for ex if i subscribe on 01.30 i get my next bill on 03.01, then 04.01 > > etc... they are considering that. > > > > of cource the issue is if i subscribe on 02.28 and i get the bill on 04.01 > > i get 03.28 - 04.01 for free but they might go for it... > > > > how's that sounding... > > > > On Thu, 11 Sep 2003, Donovan wrote: > > > > > Eh, what am I thinking... I already did this a while back > > > with leasing out Banner space. > > > > > > > > > I did this by comparing (Tom's) "Date-in-seconds-since-epoch". > > > > > > Here is the test page I did at the time: > > > > > > http://www.euca.us/admin/tests/sectodays.html > > > > > > Donovan > > > > > > > > > > > > > > > Donovan wrote: > > > > What about a simple database with the number of days in > > > > each month. You could also easily check for leap year. > > > > > > > > Donovan > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I noticed this is what Rob said but i offered a little code :) ----- Original Message ----- From: "WebDna @" To: "WebDNA Talk" Sent: Thursday, September 11, 2003 3:09 PM Subject: Re: billing system > It seems to me that all you need to do is take the number of days in the > month and compare it to the billing day of the account. > > [!]How many days are in the month -- seems to work for leap year[/!] > [math > show=f]num_of_days=({[the_month]/1/[the_year]}+{1/0/0000})-{[the_month]/1/[t > he_year]}[/math] > > Now either store the day they are billed on or strip it out some how. (for > this example we will use 31st) > > [math show=f]billday=31[/math] > > [if (([billday]>[num_of_days]) & ([num_of_days]=[date %d]))] > [then] > bill now > [/then] > [else] > normal billing cycle > [/else] > [/if] > > The above should look and see 28 days in feb (29 in those leap years) and > the 30th in those months that only have 30. > > You would need to tell the client that they are being billed once a month, > not on the same day every month. > > RonnyMc > > > > > > > ----- Original Message ----- > From: "Kalin Mintchev" > To: "WebDNA Talk" > Sent: Thursday, September 11, 2003 2:00 PM > Subject: Re: billing system > > > > > > i think we offered them a formula that whoever subscribes after 28 if any > > given month his/hers next date bill will be on the the 1st day of the > > month after the next.... > > > > for ex if i subscribe on 01.30 i get my next bill on 03.01, then 04.01 > > etc... they are considering that. > > > > of cource the issue is if i subscribe on 02.28 and i get the bill on 04.01 > > i get 03.28 - 04.01 for free but they might go for it... > > > > how's that sounding... > > > > On Thu, 11 Sep 2003, Donovan wrote: > > > > > Eh, what am I thinking... I already did this a while back > > > with leasing out Banner space. > > > > > > > > > I did this by comparing (Tom's) "Date-in-seconds-since-epoch". > > > > > > Here is the test page I did at the time: > > > > > > http://www.euca.us/admin/tests/sectodays.html > > > > > > Donovan > > > > > > > > > > > > > > > Donovan wrote: > > > > What about a simple database with the number of days in > > > > each month. You could also easily check for leap year. > > > > > > > > Donovan > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"WebDna @"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Assigning Serialized Customer Numbers (1997)
[Applescript] (2000)
problems with WebCat-Plugin ()
[format 40s]text[/format] doesn't work (1997)
a little OT (2001)
return missing item (was:WebCat Sales) (1997)
Using Plug-In while running 1.6.1 (1997)
shipCost -vs- shippingtotal ? (2000)
PCS Frames (1997)
[random] only for 1-100??? (1997)
[WebDNA] Poll: Cloud hosting (2016)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Multiple Stores and WebCatalog Prefs (1997)
carriage returns in data (1997)
Validation (2000)
Initiating NewCart (1997)
[addlineitems] display (1997)
URGENT: NO BUG, woFIELDdata & FIELDword=ww (2002)
taxTotal, grandTotal (1997)
Applescript, WebDNA, and PDF (1997)