Re: Date Range Issue
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63763
interpreted = N
texte = By the way... "Hey, that's pretty cool..." goes to Brian Fries for that bit of info.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:
By the way... "Hey, that's pretty cool..." goes to Brian Fries for that bit of info.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:
For those of you not on the WebCatalog Beta... (1997)
Bad Words Filter (2005)
New Server? (2006)
NT or Mac (1998)
Re WebDNA has reached it connection limit (2004)
hideif/showif causes error if wrapped around searches (2003)
multiple search commands (1997)
Replace and Date (2002)
Spell Check (2003)
Running _every_ page through WebCat-error.html (1997)
[listfiles] (2004)
PCS Frames (1997)
Pesky &s (2002)
WCS Newbie question (1997)
Wrapping text (1998)
Upload via Browser (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
[WebDNA] Data.gov & WebDNA (2010)
[PROTECT] Problem (2003)
Why WebDNA is not popular (2002)