Re: Date subtraction

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44252
interpreted = N
texte = I should mention that another clean way to do the days of month problem is to create a database with the month and the days of month. Then use [date %m] to lookup the days of month.>Yes, that's what I was asking. > >Thanks mucho, John > > >-Will > > >On Sunday, October 20, 2002, at 04:47 PM, John Hill wrote: > >> Are you asking how to get the days in the current month? If so: >> >> [math]({[date %m/1/%y]}+{1/0/0000})-{[date %m/1/%y]}[/math] >> >> I didn't test to see if I made a mistake, but you get the idea. (note there's no need to subtract 1). >> >> John. >> >>> I reckon so.. ;) >>> >>> Rainy weekend here tho' >>> >>> While we're at it, the formula I was working on was to extrapolate the sales in a given month based on the sales so far like so: >>> >>> At the current rate, the sales this month will be: [math]([totalordervalue]*[days_in_month])/({[date]-[startdate]})[/ math] >>> >>> Which for today would look like: >>> >>> [math] (25500*31)/18[/math] >>> >>> Assuming our sales to date in October are $25500. Any spiffy way have [days_in_month] equal the days in the current month? >>> >>> Thanks a million, >>> >>> -Will >>> >>> >>> >>> >>> On Saturday, October 19, 2002, at 07:46 PM, Alain Russell wrote: >>> >>>> Must have been a hint from somewhere to not be working on the weekend .. >>>> What do you reckon .. >>>> >>>>> Ah, yes >>>>> >>>>> That was it >>>>> >>>>> Thanks Alain... >>>>> >>>>> ! >>>>> >>>>> -Will >>>>> >>>>> >>>>> On Saturday, October 19, 2002, at 07:39 PM, Alain Russell wrote: >>>>> >>>>>> Do you have your prefs set correctly .. ? >>>>>> I get 19 when I switch the dates to match my preferences .. >>>>>> >>>>>>> Oh, and that'd be WebCat 4.5.0 on MacOSXS 10.2.1 >>>>>>> >>>>>>> -Will >>>>>>> >>>>>>> On Saturday, October 19, 2002, at 07:32 PM, NovaDerm Skincare Science >>>>>>> wrote: >>>>>>> >>>>>>>> Well, dang, that's what I thought too. >>>>>>>> >>>>>>>> But >>>>>>>> >>>>>>>> >>>>>>>>> [math]{10/20/2002}-{10/01/2002}[/math] >>>>>>>>> >>>>>>>>> Alain >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> Gives me 182 >>>>>>>> >>>>>>>> >>>>>>>> ??? >>>>>>>> >>>>>>>> -Will >>>>>>>> >>>>>>>> >>>>>>>> ------------------------------------------------------------- >>>>>>>> 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://search.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://search.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://search.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://search.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://search.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://search.smithmicro.com/ >> >> -- >> --------------------------------- >> John A. Hill >> Oak Hill Software >> Website Development/Consulting >> john@oakhillsoftware.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://search.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://search.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Date subtraction (Alain Russell 2002)
  2. Re: Date subtraction (John Hill 2002)
  3. Re: Date subtraction (Matthew Bohne 2002)
  4. Re: Date subtraction (John Hill 2002)
  5. Re: Date subtraction (Rob Marquardt 2002)
  6. Re: Date subtraction (John Hill 2002)
  7. Re: Date subtraction (NovaDerm Skincare Science 2002)
  8. Re: Date subtraction (John Hill 2002)
  9. Re: Date subtraction (NovaDerm Skincare Science 2002)
  10. Re: Date subtraction (Alain Russell 2002)
  11. Re: Date subtraction (NovaDerm Skincare Science 2002)
  12. Re: Date subtraction (Alain Russell 2002)
  13. Re: Date subtraction (NovaDerm Skincare Science 2002)
  14. Re: Date subtraction (NovaDerm Skincare Science 2002)
  15. Re: Date subtraction (Alain Russell 2002)
  16. Re: Date subtraction (Gary Krockover 2002)
  17. Re: Date subtraction (Alain Russell 2002)
  18. Date subtraction (NovaDerm Skincare Science 2002)
I should mention that another clean way to do the days of month problem is to create a database with the month and the days of month. Then use [date %m] to lookup the days of month.>Yes, that's what I was asking. > >Thanks mucho, John > > >-Will > > >On Sunday, October 20, 2002, at 04:47 PM, John Hill wrote: > >> Are you asking how to get the days in the current month? If so: >> >> [math]({[date %m/1/%y]}+{1/0/0000})-{[date %m/1/%y]}[/math] >> >> I didn't test to see if I made a mistake, but you get the idea. (note there's no need to subtract 1). >> >> John. >> >>> I reckon so.. ;) >>> >>> Rainy weekend here tho' >>> >>> While we're at it, the formula I was working on was to extrapolate the sales in a given month based on the sales so far like so: >>> >>> At the current rate, the sales this month will be: [math]([totalordervalue]*[days_in_month])/({[date]-[startdate]})[/ math] >>> >>> Which for today would look like: >>> >>> [math] (25500*31)/18[/math] >>> >>> Assuming our sales to date in October are $25500. Any spiffy way have [days_in_month] equal the days in the current month? >>> >>> Thanks a million, >>> >>> -Will >>> >>> >>> >>> >>> On Saturday, October 19, 2002, at 07:46 PM, Alain Russell wrote: >>> >>>> Must have been a hint from somewhere to not be working on the weekend .. >>>> What do you reckon .. >>>> >>>>> Ah, yes >>>>> >>>>> That was it >>>>> >>>>> Thanks Alain... >>>>> >>>>> ! >>>>> >>>>> -Will >>>>> >>>>> >>>>> On Saturday, October 19, 2002, at 07:39 PM, Alain Russell wrote: >>>>> >>>>>> Do you have your prefs set correctly .. ? >>>>>> I get 19 when I switch the dates to match my preferences .. >>>>>> >>>>>>> Oh, and that'd be WebCat 4.5.0 on MacOSXS 10.2.1 >>>>>>> >>>>>>> -Will >>>>>>> >>>>>>> On Saturday, October 19, 2002, at 07:32 PM, NovaDerm Skincare Science >>>>>>> wrote: >>>>>>> >>>>>>>> Well, dang, that's what I thought too. >>>>>>>> >>>>>>>> But >>>>>>>> >>>>>>>> >>>>>>>>> [math]{10/20/2002}-{10/01/2002}[/math] >>>>>>>>> >>>>>>>>> Alain >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> Gives me 182 >>>>>>>> >>>>>>>> >>>>>>>> ??? >>>>>>>> >>>>>>>> -Will >>>>>>>> >>>>>>>> >>>>>>>> ------------------------------------------------------------- >>>>>>>> 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://search.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://search.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://search.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://search.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://search.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://search.smithmicro.com/ >> >> -- >> --------------------------------- >> John A. Hill >> Oak Hill Software >> Website Development/Consulting >> john@oakhillsoftware.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://search.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://search.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://search.smithmicro.com/ John Hill

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:

simple [convertChars] Q (2000) search form problem.. (1997) Pgp&emailer (1997) Plugin or CGI or both (1997) [Replace] really replaces? (2000) Displaying photo attached to first record (1997) WebCat2: Items xx to xx shown, etc. (1997) PIXO support (1997) European Dates (1998) Price Change (1999) WC 2.0 frames feature (1997) Photo Album (2000) Form based Redirect (2001) FlushDatabase Suggestion (1998) using listfiles to build a database? (2000) Generating Report Totals (1997) Cart -> Date and Time (2004) OT: Site Test (2006) Initiating NewCart (1997) ExclusiveLock (2000)