Date Range search

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12472
interpreted = N
texte = How do you search a database full of records for those records that exist within a range of dates? It seems that I can search via dates greater, less than or equal than what's specified but not within a range. e.g. Our dates are in the format of 1997/07/14.

Between these Dates

Date format looks like this: [date]
After but before
I notice you can search for a range of numbers by hyphenating two numbers, but what about dates?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. Re: Number/Date Range Search (Clint Davis 2003)
  2. Number/Date Range Search (Clint Davis 2003)
  3. Re: Another date range search Q (Brian Fries 2002)
  4. Re: Another date range search Q (Gary Krockover 2002)
  5. Another date range search Q (Gary Krockover 2002)
  6. Re: Date Range Search not working (Kenneth Grome 2000)
  7. Date Range Search not working (Larry Orchier 2000)
  8. A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
  9. Re: Date Range search (Marty Schmid 1997)
  10. Date Range search (w curt eggemeyer 1997)
How do you search a database full of records for those records that exist within a range of dates? It seems that I can search via dates greater, less than or equal than what's specified but not within a range. e.g. Our dates are in the format of 1997/07/14.

Between these Dates

Date format looks like this: [date]
After but before
I notice you can search for a range of numbers by hyphenating two numbers, but what about dates?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- w curt eggemeyer

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:

Stop the madness. (1997) Grep question [parsing variables] problem (2003) Search/sort in URL Was: GuestBook example (1997) Hiding URL ? (1998) SSL (1998) 2nd WebCatalog2 Feature Request (1996) searching with groups (1997) no template caching (1997) The List is Changing (1997) Duplicate Cart ID (2001) intel webdna? (2007) WebCatalog2 for NT Beta Request (1997) Email...Thanks (1997) page redirect in webDNA (1997) suggestions for a good text editor on windows? (2005) replace problem (1999) [spawn] and [formvariables] (1999) Giving out error pages (1997) Firesite and WebCat (1999) emailer (1997)