Date Range Issue

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63761
interpreted = N
texte = Hi, I'm looping through, searching a date ranges and am running into a problem where it's pulling a few days into the next month when the number of days in the month is less than 31. Here is my search code: [search db=some.db&rnDatedatarq=[theMonth]/1/[theYear] [theMonth]/31/[theYear]&Datetype=date] Can anyone tell me how to avoid this problem? Do I actually need to know the number of days in each month in the given year? Thanks, Tana ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Date Range Issue ( Kenneth Grome 2006)
  2. Re: Date Range Issue ( "Tana Adams" 2006)
  3. Re: Date Range Issue ( Matthew Bohne 2006)
  4. Re: Date Range Issue ( "Adam O'Connor" 2006)
  5. Re: Date Range Issue ( Matthew Bohne 2006)
  6. Re: Date Range Issue ( Matthew Bohne 2006)
  7. Date Range Issue ( "Tana Adams" 2006)
Hi, I'm looping through, searching a date ranges and am running into a problem where it's pulling a few days into the next month when the number of days in the month is less than 31. Here is my search code: [search db=some.db&rnDatedatarq=[theMonth]/1/[theYear] [theMonth]/31/[theYear]&Datetype=date] Can anyone tell me how to avoid this problem? Do I actually need to know the number of days in each month in the given year? Thanks, Tana ------------------------------------------------------------- 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://webdna.smithmicro.com/ "Tana Adams"

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:

WebCat2: multiple currency support (1997) [WebDNA] Error: Sorry WebDNA server not running. (2018) user flush db (2002) security (1997) Nested tags count question (1997) Sample Tearoom Search Error (1997) Feature req. (2002) can WC render sites out? (1997) Highlighting words found in a keyword search (2003) code to phantom spacing (2001) RE: new cart IDs being assigned somehow (1997) Replto in [SendMail] (2000) Execute Applescript (1997) [WebDNA] How to set up new hosting (2013) WebCatalog for guestbook ? (1997) SiteEdit Pro Update Announcement (1997) WebCat2 Append problem (B14Macacgi) (1997) search context w shownext works! (1997) remotely creating and populating a stock inventory db - almost there! (1999) Accented chars and emailer (1998)