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:

Need help (1998) Strange intermittent WebDNA problems (2008) pop up menu's (1998) Colors in cart (2002) Not really WebCat (1997) [WebDNA] 301 redirect (2016) [WebDNA] How can I uninstall WebDNA on OS X Sierra? (2017) HTML editing and webcatalog (2000) shell problem (2003) 2.0.1 new commands and contexts (1997) best way to store prefs (1998) international time (1997) Field Problem (2000) FREE Stuff .. (2003) Size limit for tmpl editor ? (1997) Can you do this??? and other stuff (1997) Fwd: 502 Bad Gateway (1998) Help with Repost Data msg from form (1997) Webcatalog and IIS4b2 (1997) apparently to problem isolated (1997)