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:
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)