Re: Fun with Dates - finally resolved but....

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12349
interpreted = N
texte = >>Also I've happened upon an anomoly ('cause I would never cry BUG knowing >>that Grant would just make me look foolish after showing me the errors of >>my ways...). > >Hehe ... :) Are you referring to anyone I know? > >>Anyway here's my code which works for the most part: >> >> days.
>> >> >>And here's the problem: As I test the various pull-down options everthing >>appears to work fine - I get a small number of records with start dates in >>the next month, a greater number in the next 2 months etc. until I hit the >>6 month/180 days option. For whatever reason it coughs and only gives me >>only 2-3 records instead of all the records that had been found with the >>earlier options as it should... Any ideas?? > >Thanks for your excellent description of the 'anomaly', Marty. > >It just so happens that the 6 month/180 day option is dealing with a new >year - 1998 - whereas all the others options are dealing with dates in 1997 >... so maybe there's something going on when the year changes. I think >what's happening is that the 180 day option is looking at records less >than January 8, 1997 instead of less than January 8, 1998. > >Grant, what do you think about this possibility? (Don't worry, I'm not >gonna call this one a bug, I learned my lesson the last time ... :) >-ok more testing- I think Ken's on to something with it being new year related... I added another option, one for 7 months/210 days that behaves similarily as the 6 month/120 days option but it actually picks up one more record than the 6 month option. When I search using the 6 month option I get 3 records - all with a start date of 01/01/1997. The 7 month option adds in a record with a start date of 02/04/1997. These searches should really be finding records through till these dates in 1998. So it appears that when the math does its addition it is not causing the year to roll over to the next year. I'm getting more tempted but I'm still calling this a bug - until Ken does...BTW I'm running WC 2.0 w/ webstar 2.0 on a PMac 9500.-marty Associated Messages, from the most recent to the oldest:

    
  1. Re: Fun with Dates - finally resolved but.... (Christer Olsson 1997)
  2. Re: Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  3. Re: Fun with Dates - finally resolved but.... (Kenneth Grome 1997)
  4. Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
>>Also I've happened upon an anomoly ('cause I would never cry BUG knowing >>that Grant would just make me look foolish after showing me the errors of >>my ways...). > >Hehe ... :) Are you referring to anyone I know? > >>Anyway here's my code which works for the most part: >> >> days.
>> >> >>And here's the problem: As I test the various pull-down options everthing >>appears to work fine - I get a small number of records with start dates in >>the next month, a greater number in the next 2 months etc. until I hit the >>6 month/180 days option. For whatever reason it coughs and only gives me >>only 2-3 records instead of all the records that had been found with the >>earlier options as it should... Any ideas?? > >Thanks for your excellent description of the 'anomaly', Marty. > >It just so happens that the 6 month/180 day option is dealing with a new >year - 1998 - whereas all the others options are dealing with dates in 1997 >... so maybe there's something going on when the year changes. I think >what's happening is that the 180 day option is looking at records less >than January 8, 1997 instead of less than January 8, 1998. > >Grant, what do you think about this possibility? (Don't worry, I'm not >gonna call this one a bug, I learned my lesson the last time ... :) >-ok more testing- I think Ken's on to something with it being new year related... I added another option, one for 7 months/210 days that behaves similarily as the 6 month/120 days option but it actually picks up one more record than the 6 month option. When I search using the 6 month option I get 3 records - all with a start date of 01/01/1997. The 7 month option adds in a record with a start date of 02/04/1997. These searches should really be finding records through till these dates in 1998. So it appears that when the math does its addition it is not causing the year to roll over to the next year. I'm getting more tempted but I'm still calling this a bug - until Ken does...BTW I'm running WC 2.0 w/ webstar 2.0 on a PMac 9500.-marty marty@artwerks.com (Marty Schmid)

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:

X Server (1999) Database Field Additions (2000) Arrays (2000) LookUp Tag (1997) GuestBook example (1997) PIXO support (1997) Up and running ... at last !! (1997) WebCat2: Items xx to xx shown, etc. (1997) How to archive....? (1998) simple answer? [hideif] (1997) Nested vs conditional (1997) [WebDNA] WebDNA 6.2 and Mac OS X 10.5 Client / Server ? (2009) I don't think my install worked (2003) Configuring E-mail (1997) What does this error mean? (2000) question: back button prevention (1997) Fun with Dates - any progress? (1997) Help formatting search results w/ table (1997) aol not showing cart (1998) WebCat2b12 Mac.acgi--[searchstring] bug (1997)