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:

serial number generation (1997) WebCat and WebTV (1997) same bill to and ship to? (1998) Sort Issues (2000) WebCatalog2 Feature Feedback (1996) [WebDNA] Cannot read LongText data type from MySQL (2011) 'RequiredField' Question (1998) using listfiles to build a database? (2000) For those of you not on the WebCatalog Beta... (1997) Preventing code execution (2003) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) primer/tutorial question (2004) can WC render sites out? (1997) Math with Time (1997) Adding up line items. (2000) Running _every_ page through WebCat ? (1997) mail on NT (1998) service stop and restart (1997) [UPPERCASE] (1997) PCS Emailer's role ? (1997)