Re: searching by date range help needed
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15675
interpreted = N
texte = >Gary: > >There is not a general problem with the date range routines. One piece of >information, that is somewhat critical when using date mat, is the format >of the date itself. Right now, the date is expected to be in the form >mm/dd/yy or mm/dd/yyyy or dd/mm/yy etc. (depending upon the default date >format in the preferences). What is the actual date text that is being >searched? Also, you might try switching the range that your searching on >so the oldest date (-30) is before the newer one (-15). If you have a >small test case and database that doesn't work perhaps you can send it to >me privately and I'll take a look. All dates are mm/dd/yy and the data base is a monster, that is why I want to be able to search by date ranges :)I will try flopping the searches around and see what happens. The data and the code is at my night, weekend consulting gig so I will not be able to report back until tomarrow.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
Associated Messages, from the most recent to the oldest:
>Gary: > >There is not a general problem with the date range routines. One piece of >information, that is somewhat critical when using date mat, is the format >of the date itself. Right now, the date is expected to be in the form >mm/dd/yy or mm/dd/yyyy or dd/mm/yy etc. (depending upon the default date >format in the preferences). What is the actual date text that is being >searched? Also, you might try switching the range that your searching on >so the oldest date (-30) is before the newer one (-15). If you have a >small test case and database that doesn't work perhaps you can send it to >me privately and I'll take a look. All dates are mm/dd/yy and the data base is a monster, that is why I want to be able to search by date ranges :)I will try flopping the searches around and see what happens. The data and the code is at my night, weekend consulting gig so I will not be able to report back until tomarrow.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
grichter@panavise.com (Gary Richter)
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:
Emailer (1997)
Housekeeping question (1999)
remotely add + sign (1997)
OT: OSX calculator error (2004)
Cookie Question (1999)
Help! Migration to OSX W*5.2.3 breaks cybercash operation (2002)
Append File help needed (2000)
Ongoing group search problems ... (1997)
Formulas.db + Users.db (1997)
Error with [applescript] (1999)
Email Formatting and Encryption (1998)
[WebDNA] Downloading and combining RSS feeds (2012)
Crashing Web* with &issuetype=date (2000)
hidden databases (2000)
Aaron kant add (or whatever it was) (2000)
WebCat2: Items xx to xx shown, etc. (1997)
[writefile] (1997)
[Price] (1997)
problems with 2 tags (1997)
$flushdatabases question ... (1998)