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 SoftwareWebsite 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:
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 SoftwareWebsite 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:
Email Problems (2000)
Looking up two prices in database? (1997)
Languages (1997)
rotating thumbnails (1997)
Serving images from databases (1998)
ShowIf & CountChars (2000)
Replace Statement (1997)
Document Contains No Data! (1997)
A better way to do this?? (2005)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Help w/Multi User Admins (1997)
software needed (2006)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
NT error logs (1997)
won't serve .tpl (2000)
[WebDNA] webdna site down? (2011)
Trouble with Netscape (1998)
Why WebMerchant not working? (1999)
HELP WITH DATES (1997)
sorting dates (1999)