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:
Changing in a founditems tag (1999)
WC 2.0 frames feature (1997)
[shownext max (1997)
How do I get Google to crawl a WebCat site? (2003)
watch out for format_to_days on NT (1997)
db updating? (2000)
Execute Applescript (1997)
The Guru Speaks-very long reply (1998)
Bug Report, maybe (1997)
Sorting by date (1997)
PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000)
WebCat 3.0 Serial Numbers (1999)
WC2.0 Memory Requirements (1997)
formula inside database to calculate weights (1997)
Before I Can Begin . . . (1998)
How big can WebCat go? (1999)
Up and running ... at last !! (1997)
Error 11 (1996)
form data submission gets truncated (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)