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:
Cancel Subscription (1996)
Text vs. Math (2000)
More Applescript (1997)
RE: IIS4b2 and WebCatalog b19 (1997)
hmmm (2006)
[random] only for 1-100??? (1997)
[Webcat 2]Next (1997)
Re[2]: Using [Include] Context (1999)
Show items based on login Password (2003)
Pithy questions on webcommerce & siteedit (1997)
Pull down menu for categories (2000)
Searching multiple fields from one form field (1997)
Sorting a [listdatabases] (2003)
Sorting by date (1997)
Error 11 (1996)
Problems passing [SKU] with $Replace in 2.0 (1997)
WebCat2b13MacPlugIn - [include] (1997)
SMSI: databases corrupted on crash and permission issueson OSX (2002)
date formatting question (2001)
[append] problem (1997)