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:
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)