Re: More DateMath problems
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13770
interpreted = N
texte = I see what's happening and can understand how it might look like a bug, butI don't think it is. Here's why. The code in WebCatalog sees the 0000 forthe year and/or the 00 for the day and assumes the date in question isbeing added or subtracted to another date. When this occurs, it does it ona field by field basis so 1 month is either added or subtracted to theother date. This is different than converting the date to the number ofdays since X and adding or subtracting that. If you were to do that, thenyou would add a fixed number of days, 31 lets say, and the resulting datewould not be the same as adding 1 month (sometimes 31 days is a month,sometimes it is a month and a day, sometimes it's a month and 3 days). So,in the example below, the date is being treated as a date (not somethingadded or subtracted). Here's what WebCatalog thinks: The date is 1 dayless that 1/1/0000, which is 12/31/-1. Thus the month is 12. The easy fixis to use 01 instead of 00 so the dummy date is always valid. I hope thishelps.John.>The code:>[FORMAT Days_to_Date %m][MATH]{1/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m][MATH]{2/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m][MATH]{3/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m][MATH]{4/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m][MATH]{5/00/0000}[/MATH][/FORMAT]>>Returns:>12>01>02>03>04John A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
I see what's happening and can understand how it might look like a bug, butI don't think it is. Here's why. The code in WebCatalog sees the 0000 forthe year and/or the 00 for the day and assumes the date in question isbeing added or subtracted to another date. When this occurs, it does it ona field by field basis so 1 month is either added or subtracted to theother date. This is different than converting the date to the number ofdays since X and adding or subtracting that. If you were to do that, thenyou would add a fixed number of days, 31 lets say, and the resulting datewould not be the same as adding 1 month (sometimes 31 days is a month,sometimes it is a month and a day, sometimes it's a month and 3 days). So,in the example below, the date is being treated as a date (not somethingadded or subtracted). Here's what WebCatalog thinks: The date is 1 dayless that 1/1/0000, which is 12/31/-1. Thus the month is 12. The easy fixis to use 01 instead of 00 so the dummy date is always valid. I hope thishelps.John.>The code:>[FORMAT Days_to_Date %m]
[math]{1/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m]
[math]{2/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m]
[math]{3/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m]
[math]{4/00/0000}[/MATH][/FORMAT]>[FORMAT Days_to_Date %m]
[math]{5/00/0000}[/MATH][/FORMAT]>>Returns:>12>01>02>03>04John A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 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:
Re[2]: Enhancement Request for WebCatalog-NT (1996)
'does not contain' operator needed ... (1997)
[OT] MacOs IE5 topmargin and leftmargin bug (2000)
ReadDateFormat bug in 3.x (1998)
Up and running ... at last !! (1997)
searchable list archive (1997)
Clearing orders and database help! (1997)
database freeze (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Upgrade to wsV (2004)
Alternating colors (1997)
WebDNA 6.0 Report (2004)
Summ=T Problem (1997)
Convert characters (2002)
Which GUI HTML editors work with WC ? (1997)
How do I make this faster???? (2000)
Outsourcing partnership ... (2005)
[WebDNA] sendmail - gives an "error -1" (2018)
Formatting a .txt file (1998)
Locking up with WebCatalog... (1997)