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:

    
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:

formvariables not passing (2000) Reference data: ip-to-country (2004) Web Catalog Instability (2000) Itools, WEBCAT OSX (2003) writefile and deletefile (1998) plugin-acgi, different results (1997) WebCat b13 CGI -shownext- (1997) [WebDNA] lighttpd and gzip compression with webdna? (2015) change the number format (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Protect vs Authenicate (1997) Sort Order on a page search (1997) Searching for Email Address (2004) WebCat2 several catalogs? (1997) Euro WebDNA Conference (2004) Remove me from your list immeadiately (1998) [WebDNA] DNA suffix (2008) spawn (1998) Redirect (2000) can WC render sites out? (1997)