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 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  2. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  3. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  4. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  5. Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006)
  6. Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006)
  7. Re: Help with searching dates from mysql dump & searching ( Grant Hulbert 2006)
  8. Help with searching dates from mysql dump & searching between ( "Olin Lagon" 2006)
  9. Re: Searching Dates (frank@usinter.net 2000)
  10. Re: Searching Dates (frank@usinter.net 2000)
  11. Re: Searching Dates (Joseph D'Andrea 2000)
  12. Re: Searching Dates (Glenn Busbin 2000)
  13. Re: Searching Dates (John Butler 2000)
  14. Searching Dates (frank@usinter.net 2000)
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/ 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)