Re: Date Range Issue

This WebDNA talk-list message is from

2006

It keeps the original formatting. numero = 63772
interpreted = N
texte = Hi Tana,I know that some other webdna programmers have already given you a solution to your date searching problem, but here's another set of parameters that should work just as well:search db=some.db&group1field=Date&group2field=Date&bwgroup1datarq=[theMonth]&wagroup2datarq=[theYear]This totally ignores the "day of the month" and retrieves all days of the specified month and year, which is what you want, right? As they say, there's more than one way to skin a cat ... :)Sincerely,Kenneth Gromewww.kengrome.comOn Fri, 6 Jan 2006 11:02:36 -0800, 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/ Associated Messages, from the most recent to the oldest:

Re: Date Range Issue ( Kenneth Grome 2006) Re: Date Range Issue ( "Tana Adams" 2006) Re: Date Range Issue ( Matthew Bohne 2006) Re: Date Range Issue ( "Adam O'Connor" 2006) Re: Date Range Issue ( Matthew Bohne 2006) Re: Date Range Issue ( Matthew Bohne 2006) Date Range Issue ( "Tana Adams" 2006)

Hi Tana,I know that some other webdna programmers have already given you a solution to your date searching problem, but here's another set of parameters that should work just as well:search db=some.db&group1field=Date&group2field=Date&bwgroup1datarq=[theMonth]&wagroup2datarq=[theYear]This totally ignores the "day of the month" and retrieves all days of the specified month and year, which is what you want, right? As they say, there's more than one way to skin a cat ... :)Sincerely,Kenneth Gromewww.kengrome.comOn Fri, 6 Jan 2006 11:02:36 -0800, 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/ Kenneth Grome

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:

Limitations on fields? Server is crashing (1997) HELP WITH DATES (1997) Final invoice problems (1998) Bug Report, maybe (1997) $adminput doesn't allow [include] files (1997) All questions are welcome on this list (1997) [WebDNA] thisAutonumber? (2011) Summary search -- speed (1997) Cancel Subscription (1996) Problems searching from a FORM (1997) WebCatalog/Mac 2.1b2 New Features (1997) [WebDNA] export db data for importing into Microsoft Outlook calendar? (2011) version 2 for NT (1997) syntax question, not in online refernce (1997) Showif dates... (2002) [shownext] and descending order (1997) Configuring E-mail (1997) Fwd: search engine friendly URLS (Mac) (1998) SQL (2004) Search design (1997)