Re: Date Range Issue
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 63762
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Showif dates... (2002)
WebCat2 beta 11 - new prefs ... (1997)
Multi-processor Mac info ... (1997)
WebCatalog for Postcards ? (1997)
Separate SSL Server (1997)
Error: Missing c in orderfile???? (2005)
[WebDNA] I can't log into WebDNA (2014)
Unable to view next 101-200 (1997)
[WebDNA] Why doesn't this returnraw redirect to the new page? (2009)
TaxTotal Problem (1997)
Arrays (2000)
[WebDNA] W3C Valid XHTML/CSS WebDNA Store templates (2009)
showif comparison begins w/ and contains (1997)
Help formatting search results w/ table (1997)
WebCatalog f2 Installation (1997)
Large sites (2003)
[WebDNA] Competitors! (2008)
Database changes (1998)
[index] (1997)
Navigator Parsing (1997)