[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:

[shell] wget (2004) Talk List Suggestions (1997) creator code (1997) Opinion: [input] should be called [output] ... (1997) Zipcodes (1998) Linux ODBC and the ODBC Bridge (2000) Multiple security dbs (1997) [format] problem (2001) Strange DB could not be found error (2005) For those of you not on the WebCatalog Beta... (1997) search w/international chars (1999) Setting up shop (1997) WebCommerce: Folder organization ? (1997) tcpsend formatting issue ... (2004) What file? (1997) [OT] Appropriate Signature??? (2003) OT: Prevent Caching js Files (2003) listwords and delimiters.. showing blank word? (2004) syntax question, not in online refernce (1997) notification solutions (1997)