Re: Help with dates
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38267
interpreted = N
texte = Will Starck wrote: > > > If you want total sales per month, there is unfortunately no way in > > WebCat to get the last day of the month, but there is a way to get > > the first day of the next and subtract 1. Try something like this: > > > John, what do you mean by this? > What do I mean by what? Total sales per month = sales for all dates from the first of the month to the last day of the month. That was not what Gorana was using in the search criteria. The search was looking for sales between the 1st and the 31st of each month, even for months with less than 31 days (so 31 Sept is actually 1 Nov).There is no way to automatically get the last day of a month from WebCat. You could just have a lookup table:month lastday 1 31 2 28 3 31 4 30 ...but unfortunately, this doesn't cover leap years. It is easier to use the built in month logic which WebCat does have and back off. So the last day of March is the first day of April minus 1.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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:
Will Starck wrote: > > > If you want total sales per month, there is unfortunately no way in > > WebCat to get the last day of the month, but there is a way to get > > the first day of the next and subtract 1. Try something like this: > > > John, what do you mean by this? > What do I mean by what? Total sales per month = sales for all dates from the first of the month to the last day of the month. That was not what Gorana was using in the search criteria. The search was looking for sales between the 1st and the 31st of each month, even for months with less than 31 days (so 31 Sept is actually 1 Nov).There is no way to automatically get the last day of a month from WebCat. You could just have a lookup table:month lastday 1 31 2 28 3 31 4 30 ...but unfortunately, this doesn't cover leap years. It is easier to use the built in month logic which WebCat does have and back off. So the last day of March is the first day of April minus 1.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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 Peacock
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:
Cart passing in URL... (2004)
Bug or syntax error on my part? (1997)
[tcpsend] (2001)
Late on Friday.... brain fried (2002)
Buying sans cart (1997)
Questions. (1998)
Help with sorting search results sorting (1998)
Emailer setup (1997)
A question about security (1998)
Unique Sort (2003)
Upgrading old WebCat Database Files (1997)
2nd WebCatalog2 Feature Request (1996)
Doing VALIDCARD right? (1998)
WebDNA to Apache RewriteMap (2005)
MOOOOOO (2000)
WebDNA5 & XML (2003)
Missing something simple?? (1998)
(1997)
WC1.6 to WC2 date formatting -FIXED! (1997)
Triggers (2003)