Date range

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63853
interpreted = N
texte = 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/ 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)
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/ Christophe Billiottet

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:

converchars in sendmail context.... (2004) Number of files in a directory (2006) WebCatalog for guestbook ? (1997) Add Unit Ship Cost to Cart (2000) using showpage and showcart commands (1996) Next X hits (1996) [WebDNA] [listwords] and [index] (2009) Running 2 two WebCatalog.acgi's (1996) OT - SMSI complaint (2001) Reminder... (2003) Hard Questions ? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Problems with [Search] param - Mac Plugin b15 (1997) Here is the code: (2000) WebCatalog/Mac 2.1b2 New Features (1997) need e-commerce recommendation (2004) Error Page? (1997) [carts] and databases (1997) NT vs Mac (1997) WC2.0 Memory Requirements (1997)