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:

SQL Changes in 3.0.7? (2000) [WebDNA] [OT] htaccess question (2017) Trouble with Netscape (1998) [WebDNA] SENDMAIL (2017) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) portal (2002) Searching for all records (1998) Pull Down Search (2000) [WebDNA] GREP question (2010) syntax question, not in online refernce (1997) Variables from a long text string (2000) [format 40s]text[/format] doesn't work (1997) Mac v. NT (1998) Emailer (1997) Webcat/Webmerchant part II (1998) Re:WebCatalog f2 Installation (1997) Robert Minor duplicate mail (1997) form data submission gets truncated (1997) carriage returns in data (1997) Ignoring [OrderFile] context (2005)