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 same issue. 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) and also 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 and let 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 Of Christophe Billiottet Sent: Friday, January 20, 2006 7:56 AM To: WebDNA Talk Subject: Date range Hi 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=date I just noticed today that if [month]=11 and [year]=2005, then this code sorts 11/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 to Web 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 same issue. 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) and also 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 and let 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 Of Christophe Billiottet Sent: Friday, January 20, 2006 7:56 AM To: WebDNA Talk Subject: Date range Hi 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=date I just noticed today that if [month]=11 and [year]=2005, then this code sorts 11/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 to Web 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:

WCS Newbie question (1997) (1997) SMSI: databases corrupted on crash and permission issueson OSX (2002) Problem with updating to 2.1.1 (1998) search/showif issues (2000) Mac Vs WindowsNT (1997) how do I delete 1 of 2 identical records? (2003) Email Format (Umlaut) (2004) Semi-OT: PanIP patent infringement case (2001) How to include weather (2000) # of real domains on 1 web server (1997) WebCatalog2 for NT Beta Request (1997) Silence before the storm? (2004) calculating tax rates, mail order solutions and version 2 (1997) AOL (1999) Next X hits (1996) Re:no [search] with NT (1997) Question on TABLES (2003) Multiple edits/replacementsd to db. Possible? (1997) WebMerchant 1.6 and SHTML (1997)