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:

ShoppingCart Woes (1998) Where's Cart Created ? (1997) Force leading zeros (1998) Help! Strange happenings... (1997) Firesite and [referrer] atg broke (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) How to Display text in empty fields (1997) Cookie Problems (2000) Compressed cookies? (2003) listfiles sort?! (2005) [isfile] ? (1997) Date search bug (1997) Encrypt Decrypt URL UnURL Weirdness (2001) WebCat2 - [format thousands] (1997) several .hdr files with one db file? (1999) Retrieve deleted files (2001) Spell Check (2000) Bookmarked URL with cart (1998) Remote Administration (1998) Shared conversion under WebTen (1998)