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:
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:
Webcatalog 2.1* and Personal Web Server 4.0 (1998)
Help! WebCat2 bug (1997)
RE: Remote delivery (1998)
[ShowNext] feature in 2.0 (1997)
Quit revisited (1997)
Auto Unsubscribe (2000)
RE: ShowNext Command (1997)
WebCat b15 Mac plug-in (1997)
List Address Changed! (1998)
Generating unique SKU from [cart] (1997)
WC2b12: Yes, Formulas.db is for real (1997)
[format 40s]text[/format] doesn't work (1997)
WebCatalog can't find database (1997)
Coding Standards - are there any ? (2003)
Classifieds (2000)
emailer error 103 part ii (1997)
WebCat 4.0 (2000)
Unexpected error (1997)
my price won't move (1997)
Which GUI HTML editors work with WC ? (1997)