Searching Dates
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35259
interpreted = N
texte = Why do you suppose I get such strange results with this code? I'm just searching adatabase for dates, and on months with 30 days, I get results of 31 days. I get thefirst 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/
Associated Messages, from the most recent to the oldest:
Why do you suppose I get such strange results with this code? I'm just searching adatabase for dates, and on months with 30 days, I get results of 31 days. I get thefirst 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/
frank@usinter.net
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:
4.0.2b4 (2000)
[OT] Disable/enable field (2003)
WebCat editing, SiteGuard & SiteEdit (1997)
Opinion: [input] should be called [output] ... (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Problems appending to database (1997)
Error -108 (1997)
Configuring E-mail (1997)
Pithy questions on webcommerce & siteedit (1997)
Sample Tearoom Search Error (1997)
FM PRO Compatibility Issue - Single Database w/o Conversions (1997)
Typhoon Rev. and PCS store problems (1999)
Merging databases (1997)
WebCat2: Items xx to xx shown, etc. (1997)
New Plug-in and Type 11 errors (1997)
Webcat 4.5.1 equivalent of autonumber (2003)
PCS Emailer's role ? (1997)
Sort & Shownext (1999)
Not really WebCat (1997)
Where's Cart Created ? (1997)