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:

    
  1. Re: Date range Problem ( "David Bastedo" 2006)
  2. Re: Date range Problem ( Jesse Proudman 2006)
  3. Date range Problem ( "David Bastedo" 2006)
  4. Re: Date range ( Gary Krockover 2006)
  5. Re: Date range ( "Dan Strong" 2006)
  6. Re: Date range ( Gary Krockover 2006)
  7. Re: Date range ( sbraun 2006)
  8. Re: Date range ( Chris 2006)
  9. Re: Date range ( "WebDna @ Inkblot Media" 2006)
  10. Date range ( Chris 2006)
  11. Re: Date Range Issue ( Kenneth Grome 2006)
  12. Re: Date Range Issue ( "Tana Adams" 2006)
  13. Re: Date Range Issue ( Matthew Bohne 2006)
  14. Re: Date Range Issue ( "Adam O'Connor" 2006)
  15. Re: Date Range Issue ( Matthew Bohne 2006)
  16. Re: Date Range Issue ( Matthew Bohne 2006)
  17. Date Range Issue ( "Tana Adams" 2006)
  18. Re: Another date range search Q (Brian Fries 2002)
  19. Re: Another date range search Q (Gary Krockover 2002)
  20. Another date range search Q (Gary Krockover 2002)
  21. searching by date ranges (Alan 2000)
  22. Re: Date Range Search not working (Kenneth Grome 2000)
  23. Re: SEARCH DATE RANGE (Kenneth Grome 2000)
  24. SEARCH DATE RANGE (Robert Kudrle 2000)
  25. Re: SEARCH DATE RANGE (Conley Hanson 2000)
  26. Re: Showif date range comparison (Kenneth Grome 1999)
  27. Re: Showif date range comparison (es-sleestak 1999)
  28. Re: Showif date range comparison (Ben Weinberg 1999)
  29. Re: Showif date range comparison (Kenneth Grome 1999)
  30. Re: Showif date range comparison (Ben Weinberg 1999)
  31. Re: Showif date range comparison (John Jakovich 1999)
  32. Showif date range comparison (Ben Weinberg 1999)
  33. Re: date range (Gary Richter 1998)
  34. Re: Date Range works (John Hill 1997)
  35. Re: searching by date range help needed (Kenneth Grome 1997)
  36. Re: searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  37. searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  38. A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
  39. Re: Date Range search (Marty Schmid 1997)
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:

[WebDNA] Domain upgrade questions (2009) Deleting Orders (1997) Sort & Shownext (1999) Showif, Hideif reverse logic ? (1997) Customer login feature (2004) MATH PROBLEM (1997) getchars broken? (1997) [SearchString] usage (1997) [Webcat 2]Next (1997) BinaryBody for ReturnRaw (2003) can you take a look (2003) pc (1997) frames & carts (1997) Sorry, WebDNA Server Not Running! (2005) Scientific notation to number, a solution? (2001) SiteEditPro (1996) why do I get authorization requests, even though (1999) Credit Card not accepted (1998) [BULK] [WebDNA] A new commerce system for v7+ (2011) Newbie questions (1999)