Re: Date Range Issue

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63765
interpreted = N
texte = I just read that... I cinfused myself. It's been a long week. Given your application... I don't know if it will work. You may need to [math]{[theMonth]/0/[theYear]}[/math] to do the comparison. Matthew Bohne wrote: > 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/ > ------------------------------------------------------------- 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)
I just read that... I cinfused myself. It's been a long week. Given your application... I don't know if it will work. You may need to [math]{[theMonth]/0/[theYear]}[/math] to do the comparison. Matthew Bohne wrote: > 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/ > ------------------------------------------------------------- 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:

WebCat hosting providers? (1997) File commands and Wild Cards ?? (1998) different show next (1997) File Maker Pro Value List Field Export Proplem... (2000) PSC recommends what date format yr 2000??? (1997) [SHOWIF] (1997) Re:Formulas.db / Quantity Discount problem (1998) Calendar Snippet Problems (1998) Feedback Please (2003) IIS4/IIS3 and WebCatalog registry settings (1998) [WebDNA] Stores (2013) Re:2nd WebCatalog2 Feature Request (1996) [ShowNext] (1997) Bug in capitalize ... ? (2003) Searching multiple Databases (1997) can WC render sites out? (1997) My web page only... (2003) [WebDNA] Sending 100 mails an hour then pausing (2010) CommandSecurity? (1997) [UPPERCASE] (1997)