Re: Searching Dates
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35261
interpreted = N
texte = You're not searching for the day of the month. You're just searching forthe month and year. The day of the month is given in your search. You couldhave [month]/99/[year] and it would show February 99, 2000.I think.Maybe.I dunno.>Why do you suppose I get such strange results with this code? I'm just>searching a>database for dates, and on months with 30 days, I get results of 31 days.>I get the>first day of the next month. If I search for April 2000, I get May 1st in>the results.>For months with 31 days I don't have any problem. This should work, yes?>Curious...> Webcat 3.0, NT.>>[search db=master.db&rnDATEdatarq=[month]/01/[year]>[month]/31/[year]&DATEtype=date&asDATEsort=1]>[founditems]>
[date] | [sales] | [commission] | [discount] |
>>[/founditems]>[/search]>>Any ideas on what may be wrong?>>Thanks,>>Frank>>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list
.>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to>>Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You're not searching for the day of the month. You're just searching forthe month and year. The day of the month is given in your search. You couldhave [month]/99/[year] and it would show February 99, 2000.I think.Maybe.I dunno.>Why do you suppose I get such strange results with this code? I'm just>searching a>database for dates, and on months with 30 days, I get results of 31 days.>I get the>first day of the next month. If I search for April 2000, I get May 1st in>the results.>For months with 31 days I don't have any problem. This should work, yes?>Curious...> Webcat 3.0, NT.>>[search db=master.db&rnDATEdatarq=[month]/01/[year]>[month]/31/[year]&DATEtype=date&asDATEsort=1]>[founditems]>[date] | [sales] | [commission] | [discount] |
>>[/founditems]>[/search]>>Any ideas on what may be wrong?>>Thanks,>>Frank>>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to>>Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Glenn Busbin
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:
I need Typhoon Pro Tonight! (1999)
WebCatalog [FoundItems] Problem - LONG - (1997)
upgrading (1997)
Frames and cart values (1998)
Duplicate Cart Problem in Netscape (2000)
[date format] w/in sendmail (1997)
[WriteFile] problems (1997)
MultiGroupChecker (2000)
[math] show=F exists? (1997)
[WebDNA] [OT] Talk list (2009)
RE: Error -108 (1997)
Logging purchases (1997)
emailer (1997)
Weird problems with [SHOWIF]s (1997)
[UPPERCASE] (1997)
New Command prefs ... (1997)
Secure Web Server (1999)
textarea inputs and returns (1999)
problems with 2 tags (1997)
Extended [ConvertChars] (1997)