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:

Clickable maps and WebCatalog? (1996) Firewalls - What's Good? (1999) [WebDNA] how to purge webdna cache of templates? (2009) is your webDNA site 'froogle' ready ??? (2003) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Text data with spaces in them... (1997) [WebDNA] [OT] WSC Forum (2009) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] WebDNA code displaying on page (2012) completed orders database (1997) View a Order file (1999) Thanks Grant (1997) Purchase Plugin Missing (1996) Shared conversion under WebTen (1998) Where is f2? (1997) [math] variable question (1997) Calculating multiple shipping... (1997) WebCat2 - [format thousands] (1997) Country & Ship-to address & other fields ? (1997) There's a bug in the math context ... (1997)