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-WillOn 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:
Yes, that's what I was asking.Thanks mucho, John-WillOn 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)