Re: Date range
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63855
interpreted = N
texte = Someone else (Tana Adams I believe) was just (Jan 6th) having this sameissue. Matthew Bohne offered the following code:--------------------------Pseudo Code://Grab the month and create a new variable called 'nextMonth'[text]nextMonth=[math] [theMonth] + 1 [/math][/text][text]nextYear=[theYear][/text]//Test to see if nextMonth is greater than 12, if so reset it to 1 (Jan) andalso add a year to nextYear [showif [nextMonth]>12] [text][nextMonth]=1[/text] [text][nextYear]=[math][theYear]+1[/math][/text][/showif]//Do your search[search db=some.db&rnDatedatarq=[theMonth]/1/[theYear][nextMonth]/0/[nextYear]&Datetype=date]This should grab everything within the range. Hope it helps.-Adam----------------------I have not personally tried it, but it appears to be sound. Give it try andlet us know if this helps.Just another lowly WebDna Developer,Ron Kirkland-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfChristophe BilliottetSent: Friday, January 20, 2006 7:56 AMTo: WebDNA TalkSubject: Date rangeHi everyone!we have a database with dates mm/dd/yy and we list results for specific [month] and [year] like this:rnfecha_fact_comprdatarq=[month]/01/[year] [month]/31/[year] &fecha_fact_comprtype=dateI just noticed today that if [month]=11 and [year]=2005, then this code sorts11/01/05 to 12/01/05 INCLUDED (12/01/05 should be excluded)probably because there are only 30 days in November. My guess is WebDNA recognizes "12/01/05" as "11/31/05".Is there another way to list results month by month without getting this sort of behaviour?sincerely,chris-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Someone else (Tana Adams I believe) was just (Jan 6th) having this sameissue. Matthew Bohne offered the following code:--------------------------Pseudo Code://Grab the month and create a new variable called 'nextMonth'[text]nextMonth=[math] [theMonth] + 1 [/math][/text][text]nextYear=[theYear][/text]//Test to see if nextMonth is greater than 12, if so reset it to 1 (Jan) andalso add a year to nextYear [showif [nextMonth]>12] [text][nextMonth]=1[/text] [text][nextYear]=[math][theYear]+1[/math][/text][/showif]//Do your search[search db=some.db&rnDatedatarq=[theMonth]/1/[theYear][nextMonth]/0/[nextYear]&Datetype=date]This should grab everything within the range. Hope it helps.-Adam----------------------I have not personally tried it, but it appears to be sound. Give it try andlet us know if this helps.Just another lowly WebDna Developer,Ron Kirkland-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfChristophe BilliottetSent: Friday, January 20, 2006 7:56 AMTo: WebDNA TalkSubject: Date rangeHi everyone!we have a database with dates mm/dd/yy and we list results for specific [month] and [year] like this:rnfecha_fact_comprdatarq=[month]/01/[year] [month]/31/[year] &fecha_fact_comprtype=dateI just noticed today that if [month]=11 and [year]=2005, then this code sorts11/01/05 to 12/01/05 INCLUDED (12/01/05 should be excluded)probably because there are only 30 days in November. My guess is WebDNA recognizes "12/01/05" as "11/31/05".Is there another way to list results month by month without getting this sort of behaviour?sincerely,chris-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
"WebDna @ Inkblot Media"
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:
Re:Merging databases (1997)
Forms IMG tag[OT] (2001)
all records returned. (1997)
[isfile] ? (1997)
Approved Carts (1999)
[CreateDate] tag? (1998)
Protect (1997)
[WebDNA] Browser types (2010)
weight based shipping cost questions (1997)
Logging purchases (1997)
Showing specific [cart] contents (1998)
bug report -- leading < character (1998)
Creating folders and deleting files (1997)
Cookies not setting on IE (2002)
help on brickwalls (2003)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Not really WebCat (1997)
simple [convertChars] Q (2000)
Convert characters (2002)
HELP WITH DATES (1997)