Re: Date subtraction

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44242
interpreted = N
texte = 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/ 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)
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/ NovaDerm Skincare Science

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:

PCS Frames (1997) Less than or equal to........ (1997) Where's Cart Created ? (1997) Show only certain items (2002) encrypt/decrypt - are docs correct?? (2002) Do .tpls A Max File Size? (1998) Removing items from a cart is wonky... (1998) Problems with Search between X and Y (1999) form ENCTYPE confusion (2003) Re:Non-technical messages ... (1997) off-topic: SMS interface? (2001) Country & Ship-to address & other fields ? (1997) sort without the or a (1998) Multiple Ad databases? (1997) Extended [Concvertchars] needed (1997) Emailer on NT! (1998) OT - robots.txt (2003) emailer (1997) webcat error log (1998) Re:Multiple appends with checkboxes (1998)