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:

$Append for Users outside the ADMIN group (1997) Problem with [isFile] [isFolder] (wc 3.0.4, iis 4) (1999) Limitations on fields? Server is crashing (1997) Problems with Search between X and Y (1999) controlling form elements (slightly OT) (2003) emailer settings and control questions (1997) For those of you not on the WebCatalog Beta... (1997) Mac 2.1b2 speed (1997) can WC render sites out? (1997) [OT] (waaaay OT) (2004) Questions! (2000) [WebDNA] Setting secure cookie (2009) [WebDNA] fastcgi 7+ & [cart]? (2010) RE: Formulas.db + Users.db (1997) Questions about maximum (1999) Trigger action Quandry (2002) Compressed cookies - follow-up (2003) [WebDNA] inputed text getting scrambled up in DB (2012) Searchable list archive (1997) grouping fields question (1998)