Re: Date Math bug

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16856
interpreted = N
texte = The concept is, as you have deduced, adding numbers to a particular field doesn't change the others. This is only ambiguous in the month case. If you want the last day of the next month when the next month is shorter, should 2/28/1998 + 1 month go to 3/28/1998 or 3/31/1998? This is the ambiguous part.If you always wanted the last day of the next month, you could do some WebDNA that figured out the number of days in the next month and added it to the current date. This is not as clean, but workable. I hope this helps.John.>[MATH DATE]{03/31/1998}+{01/00/0000}[/MATH] >returns >05/01/1998 > >While I understand that May 1st is being interpreted as April 31st, I >consider this a bug. Adding 1 month to the last day of the month should >give the last day of the next month. > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Date Math bug (Dale LaFountain 1998)
  2. Re: Date Math bug (John Hill 1998)
  3. Date Math bug (Michael Winston 1998)
  4. Re: Webcat 2.0.1 date math bug -> Crash! (wahl@dnai.com (Bernt Wahl) 1997)
  5. Re: Webcat 2.0.1 date math bug -> Crash! (Kenneth Grome 1997)
  6. Webcat 2.0.1 date math bug -> Crash! (Dale LaFountain 1997)
The concept is, as you have deduced, adding numbers to a particular field doesn't change the others. This is only ambiguous in the month case. If you want the last day of the next month when the next month is shorter, should 2/28/1998 + 1 month go to 3/28/1998 or 3/31/1998? This is the ambiguous part.If you always wanted the last day of the next month, you could do some WebDNA that figured out the number of days in the next month and added it to the current date. This is not as clean, but workable. I hope this helps.John.>[MATH DATE]{03/31/1998}+{01/00/0000}[/MATH] >returns >05/01/1998 > >While I understand that May 1st is being interpreted as April 31st, I >consider this a bug. Adding 1 month to the last day of the month should >give the last day of the next month. > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com John Hill

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:

WebDNA deletes major DB data big time (2004) CyberSource (2005) (1997) Missing from Docs [folderName] (1997) How To question on setting up downloads (1997) Unable to open the demo file (1998) WebCat2 - Getting to the browser's username/password data (1997) Size issues (2001) Webstar 1.3.1 PPC (1997) Various Problems (1997) UPS QuickCost and More (2000) Upgrading old WebCat Database Files (1997) WebCatalog - Mac vs Linux (2000) Anyone get WebDNA working on a windows XP Home box? (2006) Re:no [search] with NT (1997) Location of Browser Info.txt file (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) [HIDEIF] inside [FOUNDITEM] (1997) More on the email templates (I like it) (1997) Anybody running directory indexer? (1998)