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:

WebCat editing, SiteGuard & SiteEdit (1997) Help formatting search results w/ table (1997) More Shopping Cart Problems (2000) Using [showif] (2000) Numbers and Numbers and Me (1999) Applescript, WebDNA, and PDF (1997) Seeking Better Display of results... (1997) Harvesting invalid email addresses from bounced emails??? (2000) database size? (1997) db caching in bizarre ways (2001) NT vs Mac (1997) WebCatalog as another user on mac osx (2001) [WebDNA] parsing xml (2010) Design Help Needed (1998) WC1.6 to WC2 date formatting (1997) [SHELL] SSH more problems (2003) Database Updates (1997) RE: [WebDNA] Cannot get WebDNA and MySQL working. (2015) [purgeDatabase], [replaceChars] and others ... (1997) How far do [showif]s go? (1997)