Re: Date Range Issue

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63762
interpreted = N
texte = You can use [theMonth]/0/[theYear] to get the last day of the previous month but I don't know if 1/31/2006=2/0/2005. Otherwise, yes, you'll have to have the number of days in tables, compare to see if it's a leap year and read the month from the db. Tana Adams wrote: >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/ > > > ------------------------------------------------------------- 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)
You can use [theMonth]/0/[theYear] to get the last day of the previous month but I don't know if 1/31/2006=2/0/2005. Otherwise, yes, you'll have to have the number of days in tables, compare to see if it's a leap year and read the month from the db. Tana Adams wrote: >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/ > > > ------------------------------------------------------------- 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/ Matthew Bohne

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:

Showif dates... (2002) WebCat2 beta 11 - new prefs ... (1997) Multi-processor Mac info ... (1997) WebCatalog for Postcards ? (1997) Separate SSL Server (1997) Error: Missing c in orderfile???? (2005) [WebDNA] I can't log into WebDNA (2014) Unable to view next 101-200 (1997) [WebDNA] Why doesn't this returnraw redirect to the new page? (2009) TaxTotal Problem (1997) Arrays (2000) [WebDNA] W3C Valid XHTML/CSS WebDNA Store templates (2009) showif comparison begins w/ and contains (1997) Help formatting search results w/ table (1997) WebCatalog f2 Installation (1997) Large sites (2003) [WebDNA] Competitors! (2008) Database changes (1998) [index] (1997) Navigator Parsing (1997)