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:

[ConvertChars] problem (1997) More Applescript (1997) PCS Frames (1997) Running WebCat from a CD-ROM (1997) OT: About.com/Sprinks click-through fraud (2001) Re:Finding max value for a field (1997) A quickie question (1997) Cart Question: The Epic Saga (1998) [WebDNA] Froala Editor working with WebDNA (2016) SpiderBotLock! (2003) indexing dates (1998) Getting Emailer to send mail (1997) [ot] Bluetooth Phones That Allow SSH (2004) Netscape Communicator 4 chops off URLs (was No Data) (1997) Document Contains No Data! (1997) WebCatalog2 Feature Feedback (1996) No luck with taxes (1997) Searching multiple fields from one form field (1997) Country & Ship-to address & other fields ? (1997) cart converting to scientific notation format (2001)