Re: Help with dates
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38269
interpreted = N
texte = > 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 > Hi againI think that the date range doesn't make a difference. My sums for total for each month are correct, but the problem is in the way that I am taking a month away from todays date and with that I am skiping February. I think. Gorana ------------------------------------------------------------- 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:
> 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 > Hi againI think that the date range doesn't make a difference. My sums for total for each month are correct, but the problem is in the way that I am taking a month away from todays date and with that I am skiping February. I think. Gorana ------------------------------------------------------------- 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/
Gorana Leahy
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:
SetHeader not Working (2006)
Can't load tmpl files (1997)
Quick ShowIf question (1997)
default error on NT? (1997)
Re:Copyright ? (1997)
Aaron kant add (or whatever it was) (2000)
Summing fields (1997)
Trouble changing a variable. (2000)
Price Not Appearing (2000)
[WebDNA] webdna.us is blocked by Lightspeed Systems (2017)
Bad creator codes which cause access denied error message (1997)
MySQL and Decimals (2004)
[WebDNA] Permission Settings (2009)
Re:Emailer and encryption (1997)
WebDNA Solutions ... sorry! (1997)
BR (1997)
HomePage Caution (1997)
Re1000002: Setting up shop (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[cart] clarification... (1997)