[date] problem with %d%m%Y

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18297
interpreted = N
texte = I have noticed a bug in the [date] tag when performing math calculation on a date when the date prefs is non standard.If the date preference is set to default : %m%d%Y (such as 12/25/1997) [math date]{[date]}+90[/math] adds 90 days to the current dateIf the date preference is set to : %d%m%Y (such as 25/12/1997) [math date]{[date]}+90[/math] DOES NOT add 90 days to the current dateWhat should I do ? In France we are used to %d%m%Y and nobody understands a date when the month is given first (05/06/98 is the 5 june 1998 for us, not 6 may 1998).I have also noticed problems when adding 12 monthes to a date with the result. I have included my date-test-code so you can see what happens with the preferences of Webcatalog set to %m%d%Y or %d%m%Y. The expected result only happens with %m%d%YLaurent.---Sample code follows ----- date : [date]

date + 2 monthes : [math date]{[date]}+{00/2/0000}[/math]

date + 2 days : [math date]{[date]}+{2/00/0000}[/math]

date + 2 years : [math date]{[date]}+{00/00/0002}[/math]


date + 30 days : [math date]{[date]}+30[/math]

date + 60 days : [math date]{[date]}+60[/math]

date + 90 days : [math date]{[date]}+90[/math]

date + 365 days : [math date]{[date]}+365[/math]

date + 730 days : [math date]{[date]}+730[/math]


french format :
date + 3 monthes : [math date]{[date]}+{00/03/0000}[/math]

date + 6 monthes : [math date]{[date]}+{00/06/0000}[/math]

date + 12 monthes : [math date]{[date]}+{00/12/0000}[/math]

--
US format
date + 3 monthes : [math date]{[date]}+{03/00/0000}[/math]

date + 6 monthes : [math date]{[date]}+{06/00/0000}[/math]

date + 12 monthes : [math date]{[date]}+{12/00/0000}[/math]

--- Laurent Pladys LXir L a u r e n t P l a d y s ‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹ L X i r _____________________________________________ 1 5 5 r u e d e P i c p u s 7 5 0 1 2 P a r i s F r a n c e _____________________________________________ +33 (0)1 44 68 80 60 (tel) +33 (0)1 44 68 80 61 (fax) _____________________________________________ w w w . L X i r . n e t l t p l a d y s @ L X i r . n e t Associated Messages, from the most recent to the oldest:

    
  1. Re: [date] problem with %d%m%Y (John Hill 1998)
  2. [date] problem with %d%m%Y (Laurent Pladys 1998)
  3. Re: [date] problem with %d%m%Y (John Hill 1998)
  4. Re: [date] problem with %d%m%Y (John Hill 1998)
I have noticed a bug in the [date] tag when performing math calculation on a date when the date prefs is non standard.If the date preference is set to default : %m%d%Y (such as 12/25/1997) [math date]{[date]}+90[/math] adds 90 days to the current dateIf the date preference is set to : %d%m%Y (such as 25/12/1997) [math date]{[date]}+90[/math] DOES NOT add 90 days to the current dateWhat should I do ? In France we are used to %d%m%Y and nobody understands a date when the month is given first (05/06/98 is the 5 june 1998 for us, not 6 may 1998).I have also noticed problems when adding 12 monthes to a date with the result. I have included my date-test-code so you can see what happens with the preferences of Webcatalog set to %m%d%Y or %d%m%Y. The expected result only happens with %m%d%YLaurent.---Sample code follows ----- date : [date]

date + 2 monthes : [math date]{[date]}+{00/2/0000}[/math]

date + 2 days : [math date]{[date]}+{2/00/0000}[/math]

date + 2 years : [math date]{[date]}+{00/00/0002}[/math]


date + 30 days : [math date]{[date]}+30[/math]

date + 60 days : [math date]{[date]}+60[/math]

date + 90 days : [math date]{[date]}+90[/math]

date + 365 days : [math date]{[date]}+365[/math]

date + 730 days : [math date]{[date]}+730[/math]


french format :
date + 3 monthes : [math date]{[date]}+{00/03/0000}[/math]

date + 6 monthes : [math date]{[date]}+{00/06/0000}[/math]

date + 12 monthes : [math date]{[date]}+{00/12/0000}[/math]

--
US format
date + 3 monthes : [math date]{[date]}+{03/00/0000}[/math]

date + 6 monthes : [math date]{[date]}+{06/00/0000}[/math]

date + 12 monthes : [math date]{[date]}+{12/00/0000}[/math]

--- Laurent Pladys LXir L a u r e n t P l a d y s ‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹‹ L X i r _____________________________________________ 1 5 5 r u e d e P i c p u s 7 5 0 1 2 P a r i s F r a n c e _____________________________________________ +33 (0)1 44 68 80 60 (tel) +33 (0)1 44 68 80 61 (fax) _____________________________________________ w w w . L X i r . n e t l t p l a d y s @ L X i r . n e t Laurent Pladys

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:

absolute paths for databases? (1997) hidden databases (2000) [OT] Powerbook Tech (2005) [searchString] (1997) Summing fields (1997) REPOST: How do _you_ back up your db? (2000) founditems (1998) Trouble with formula.db (1997) Shopping Cart - prices? (1997) WebCat2final1 crashes (1997) Entry pages (was: WebCatalog MAJOR drawback) (1998) Works! (1997) WebCat2 - Getting to the browser's username/password data (1997) Orders w/in [sendmail] (1998) retain raw [cart] submitted value (2004) Weird Math and SV (1997) External Images (1998) Webcat & SIMS (1998) Locking up with WebCatalog... (1997) Problem with CC problem ? (1997)