Re: date range

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18060
interpreted = N
texte = >I would like to create 4 links where show the results based on a date range. > >This is the basic link I want to use. > >href=NewReleaseResults.tpl?command=search&db=catalog.txt&titlesort=1&eqNewR >eleasedatarq=T&searchTitle=NewRelease&Max=6>This Weeks New Releases > >The date field name is [ReleaseDate] The first link I would like to have >the results show all the items that the date is 7 or less days old. The >second link I want between 8 to 14 days old. The third I want between 15 >and 21, then 22 to 28 > >Thank you for any help you can offer. if you have a date as in 06/04/98 in the field [releasedate] then trygereleaseDatedatarq=[math date]{[date]}-{00/07/0000}[/math] for less then 7 days.and &releasedatetype=date&rnreleaseDatedatarq=[math date]{[date]}-14[/math]+[math date]{[date]}-8[/math] =============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.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: Number/Date Range Search (Clint Davis 2003)
  19. Number/Date Range Search (Clint Davis 2003)
  20. Re: Another date range search Q (Brian Fries 2002)
  21. Re: Another date range search Q (Gary Krockover 2002)
  22. Another date range search Q (Gary Krockover 2002)
  23. searching by date ranges (Alan 2000)
  24. Re: Date Range Search not working (Kenneth Grome 2000)
  25. Date Range Search not working (Larry Orchier 2000)
  26. Re: SEARCH DATE RANGE (Kenneth Grome 2000)
  27. SEARCH DATE RANGE (Robert Kudrle 2000)
  28. Re: SEARCH DATE RANGE (Conley Hanson 2000)
  29. Re: Showif date range comparison (Kenneth Grome 1999)
  30. Re: Showif date range comparison (es-sleestak 1999)
  31. Re: Showif date range comparison (Ben Weinberg 1999)
  32. Re: Showif date range comparison (Kenneth Grome 1999)
  33. Re: Showif date range comparison (Ben Weinberg 1999)
  34. Re: Showif date range comparison (John Jakovich 1999)
  35. Showif date range comparison (Ben Weinberg 1999)
  36. Re: date range (Gary Richter 1998)
  37. date range (greg 1998)
  38. Re: Date Range works (John Hill 1997)
  39. Date Range works (grichter@panavise.com (Gary Richter) 1997)
  40. Re: searching by date range help needed (Kenneth Grome 1997)
  41. Re: searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  42. searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  43. A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
  44. Re: Date Range search (Marty Schmid 1997)
  45. Date Range search (w curt eggemeyer 1997)
  46. Date Range Sorting (w curt eggemeyer 1997)
>I would like to create 4 links where show the results based on a date range. > >This is the basic link I want to use. > >href=NewReleaseResults.tpl?command=search&db=catalog.txt&titlesort=1&eqNewR >eleasedatarq=T&searchTitle=NewRelease&Max=6>This Weeks New Releases > >The date field name is [ReleaseDate] The first link I would like to have >the results show all the items that the date is 7 or less days old. The >second link I want between 8 to 14 days old. The third I want between 15 >and 21, then 22 to 28 > >Thank you for any help you can offer. if you have a date as in 06/04/98 in the field [releasedate] then trygereleaseDatedatarq=[math date]{[date]}-{00/07/0000}[/math] for less then 7 days.and &releasedatetype=date&rnreleaseDatedatarq=[math date]{[date]}-14[/math]+[math date]{[date]}-8[/math] =============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== Gary Richter

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:

OT: Poll Results (2002) Whats going on? (2000) Stats (2004) Question: Searching/Appending (1998) WebCat2b15MacPlugin - [protect] (1997) Promise of future help (1998) WCS Newbie question (1997) [WebDNA] Cheers (2008) DB Size - MAX (2004) Generating Searches on the fly? (1999) Getting total number of items ordered (1997) emailer w/F2 (1997) [OT] Theiving B*****ds (2004) need help with [sendmail] and [showif]s (1998) WebDNA on Windows questions (2007) More DateMath problems (1997) unique ascending numbers (2003) Followup question re: checksum for credit cards? (1997) using showpage and showcart commands (1996) Secure Server (1997)