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

IE Cache Problems... (1999) File Uploads... (1997) [Middle] Probs with "&" (2003) Re:Version 2.0 and 1.6 simultaneous (1997) Permissions Ignored - PLEASE HELP (2003) [WebDNA] Wishlist: ignore whitespace in database changes (2016) [isfile] ? (1997) Signal Raised (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [Q] Novice's question (1997) [OT] KeepItUp for Windows (2003) Re:no template caching (1997) formatting dates from a field ... (1997) Removing [showif] makes a big difference in speed (1997) SQL statements (2002) HELP WITH DATES (1997) Country & Ship-to address & other fields ? (1997) really wierd browser truncating (1997) format and math on the fly (1998) Web Delivery Page concept (1997)