Re: Date subtraction

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44241
interpreted = N
texte = 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/ 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)
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/ 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:

WebCatalog for Postcards ? (1997) syntax question, not in online refernce (1997) Grep Question - NOT YET SOLVED (fwd) (2003) Ok here is a question? (1997) This Code Kills My WebCatalog Dead (2003) Simple way to create unique SKU (1997) Multiple Replaces (1997) Erotic Sites (1997) WebCatalog NT beta 18 problem (1997) [ConvertChars] problem (1997) Standalone Testing (1998) SQL Connections (2004) Re2: Calculating multiple shipping... (1997) BUG REPORT -- Refusing connections! (1999) [SearchString] problem with [search] context (1997) Separate SSL Server (1997) webcat nt (1997) username/password dialogue (2001) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebCat virtual postcard is done! Thanks for the help! (1998)