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:

& in grep (2003) [OT] Who's got a cool link (2002) Exclamation point (1997) New WebDNA Forum Solution (in development) (2003) FREE Web Server Monitor FREE (1997) How To question on setting up downloads (1997) Adding a product from another site (1997) access denied problem (1997) [addlineitems] (1997) This list needs a digest: rant, rave... (1997) Re:Searching for ALL / empty form field (1997) [append] and SSL (1997) Tab Charactor (1997) Thanks for tips, more quest (1997) WebCat2 - Getting to the browser's username/password data (1997) sort problems....bug or brain fart? (1997) Re:2nd WebCatalog2 Feature Request (1996) Problem with [Search] inside of [Loop]? (1997) Need relative path explanation (1997) Encrypting userid for email (2000)