Re: [date] problem with %d%m%Y

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18296
interpreted = N
texte = Laurent:I'll take a look at it and let you know what I find. It should definitely work as you expect.John.>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 date > >If 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 >date > >What 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%Y > >Laurent. > >---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 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] 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)
Laurent:I'll take a look at it and let you know what I find. It should definitely work as you expect.John.>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 date > >If 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 >date > >What 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%Y > >Laurent. > >---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 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:

Re:UPS, FEDEX TRACKING (1999) Nested tags count question (1997) (2004) StoreBuilder Shopping Cart (2000) Exclamation point (1997) addlineitems (2003) off topic fetch vs PCS photomaster (1997) Error Msg (1998) Sorting error (1997) Quantity discount on some items? (2000) Alternating colors (1997) WC1.6 to WC2 date formatting (1997) [SubTotal] ??? (1998) SOLUTION.... Balancing randomness (2000) [WebDNA] OT: what is the "right" platform ? (2009) How much is too much? I can never remember the answer. (2002) Emailer Chokes on bad address (1997) my price won't move (1997) Type 11 errors setting up WebCAt 2 (1997) [WebDNA] Emailer & SMTP (2009)