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:

    
  1. Re: billing system ( Kalin Mintchev 2003)
  2. Re: billing system ( "WebDna @" 2003)
  3. Re: billing system ( "WebDna @" 2003)
  4. Re: billing system ( Kalin Mintchev 2003)
  5. Re: billing system ( Kalin Mintchev 2003)
  6. Re: billing system ( Kalin Mintchev 2003)
  7. Re: billing system ( Donovan 2003)
  8. Re: billing system ( Donovan 2003)
  9. Re: billing system ( Rob Marquardt 2003)
  10. Re: billing system ( John Peacock 2003)
  11. Re: billing system ( Rob Marquardt 2003)
  12. Re: billing system ( Kalin Mintchev 2003)
  13. Re: billing system ( Jesse Williams-Proudman 2003)
  14. Re: billing system ( Kalin Mintchev 2003)
  15. Re: billing system ( Kalin Mintchev 2003)
  16. Re: billing system ( Jesse Williams-Proudman 2003)
  17. Re: billing system ( Pedro Rivera 2003)
  18. billing system ( Kalin Mintchev 2003)
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:

Prices coming up 0.00 (2001) Formulas.db + Users.db (1997) Some shell fun (2004) Adding up line items. (2000) How old am I? (2004) New public beta available (1997) WebCat Contest (1998) Extended [ConvertChars] (1997) WebDNA Solutions ... sorry! (1997) Using Cookie for client specific info? (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) RE: Purchased cart being overwritten (1997) [Summary] re: Emailer setup (1997) system crashes, event log (1997) WebDNA 6.0 & MAC OS X Server 10.4.10 (2007) Mondo amounts of Mail [long] (1999) AD Error Msg (1997) WebCatalog NT (1996) Nested tags count question (1997) This list needs a digest: rant, rave... (1997)