Re: Formatting date to number - more

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 30616
interpreted = N
texte = sounds like the date set on your server could be wrong. but then again youare in Germany and I am not sure if the the [date] object interprets itdifferently there or not. In the US Month/DayofMonth/Year is the commonformat, is yours DayofMonth/Month/Year? is there a preference somewhere thatcould be tripping this up (webcat thinks it's looking at one thing but itsan other).> From: dale@gmr.dresdner.net > Reply-To: (WebCatalog Talk)> Date: Wed, 19 Apr 2000 17:20:42> To: (WebCatalog Talk)> Subject: Re: Formatting date to number - more> > Ok,> > Thanks to Erics post I found in the docs the following:> > [Format Days_To_Date %m/%d/%y]729496[/Format] yields 4/17/1997 (per the> docs)> > Which does appear to work as advertised. However, when I use> [Math]{[date]}[/Math] to get the value for today, I get a number that is> about 30000 LESS than the example which uses a date more than 3 years ago> (697573).> > When I use: (including the number of days value given by WebCat using> [Math]{[date]}[/Math]) I get a 'date' of 11/22/09> > [Format Days_To_Date %m/%d/%y]697573[/Format]> > I have my preferences set to 'text sortable' in the read format and the Date> Display format has been left to the normal default setting of %m/%d/%Y> > Could this possible be where my problem is? If I simply use [date] it> displays properly.> > Thanks for any pointers.> > -- > Dale Therio > +49 69 263 19977 office Dresdner Kleinwort Benson Research> +49 69 263 11379 fax J�rgen-Ponto-Platz 1> +49 170 934 3610 mobile 60301 Frankfurt, Germany> > >> From: Eric Ridgley >> Reply-To: (WebCatalog Talk)>> Date: Wed, 19 Apr 2000 09:56:16>> To: (WebCatalog Talk)>> Subject: Re: Formatting date to number>> >>> From the the MATH context:>> >> [Math]{[date]}[/Math] <-returns what you need.>> >>> From: dale@gmr.dresdner.net >>> Reply-To: (WebCatalog Talk)>>> Date: Wed, 19 Apr 2000 15:08:30>>> To: (WebCatalog Talk)>>> Subject: Formatting date to number>>> >>> I have been looking in the html docs and can't find the proper way to take>>> [date] and save it in my DB as the number of days since xxx (whatever date>>> the command uses).>>> >>> Any ideas?>>> >>> Thanks>>> -- >>> Dale Therio >>> +49 69 263 19977 office Dresdner Kleinwort Benson Research>>> +49 69 263 11379 fax J�rgen-Ponto-Platz 1>>> +49 170 934 3610 mobile 60301 Frankfurt, Germany>>> >>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >> >> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to>> >> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Associated Messages, from the most recent to the oldest:

Re: Formatting date to number - more (dale@gmr.dresdner.net 2000) Re: Formatting date to number - more (Kenneth Grome 2000) Re: Formatting date to number - more (Eric Ridgley 2000) Re: Formatting date to number - more (dale@gmr.dresdner.net 2000)

sounds like the date set on your server could be wrong. but then again youare in Germany and I am not sure if the the [date] object interprets itdifferently there or not. In the US Month/DayofMonth/Year is the commonformat, is yours DayofMonth/Month/Year? is there a preference somewhere thatcould be tripping this up (webcat thinks it's looking at one thing but itsan other).> From: dale@gmr.dresdner.net > Reply-To: (WebCatalog Talk)> Date: Wed, 19 Apr 2000 17:20:42> To: (WebCatalog Talk)> Subject: Re: Formatting date to number - more> > Ok,> > Thanks to Erics post I found in the docs the following:> > [Format Days_To_Date %m/%d/%y]729496[/Format] yields 4/17/1997 (per the> docs)> > Which does appear to work as advertised. However, when I use> [math]{[date]}[/Math] to get the value for today, I get a number that is> about 30000 LESS than the example which uses a date more than 3 years ago> (697573).> > When I use: (including the number of days value given by WebCat using> [math]{[date]}[/Math]) I get a 'date' of 11/22/09> > [Format Days_To_Date %m/%d/%y]697573[/Format]> > I have my preferences set to 'text sortable' in the read format and the Date> Display format has been left to the normal default setting of %m/%d/%Y> > Could this possible be where my problem is? If I simply use [date] it> displays properly.> > Thanks for any pointers.> > -- > Dale Therio > +49 69 263 19977 office Dresdner Kleinwort Benson Research> +49 69 263 11379 fax J�rgen-Ponto-Platz 1> +49 170 934 3610 mobile 60301 Frankfurt, Germany> > >> From: Eric Ridgley >> Reply-To: (WebCatalog Talk)>> Date: Wed, 19 Apr 2000 09:56:16>> To: (WebCatalog Talk)>> Subject: Re: Formatting date to number>> >>> From the the MATH context:>> >> [math]{[date]}[/Math] <-returns what you need.>> >>> From: dale@gmr.dresdner.net >>> Reply-To: (WebCatalog Talk)>>> Date: Wed, 19 Apr 2000 15:08:30>>> To: (WebCatalog Talk)>>> Subject: Formatting date to number>>> >>> I have been looking in the html docs and can't find the proper way to take>>> [date] and save it in my DB as the number of days since xxx (whatever date>>> the command uses).>>> >>> Any ideas?>>> >>> Thanks>>> -- >>> Dale Therio >>> +49 69 263 19977 office Dresdner Kleinwort Benson Research>>> +49 69 263 11379 fax J�rgen-Ponto-Platz 1>>> +49 170 934 3610 mobile 60301 Frankfurt, Germany>>> >>> >>> >>> ------------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list .>>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to>>> >> >> >> ------------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to>> >> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Eric Ridgley

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:

# fields limited? (1997) Errata: WCS Newbie question (1997) Adding Message to Order (1997) [defined]ish (1997) Next X hits (1996) Providing hard copy of database to client (1997) Suse linux 9.0 AMD64 (2004) Emailer Problem (2000) Email encryption (1998) Same Database needed on two machines (2002) inconsistent webcat calculation? (1997) Last digit of Credit Card Stripped (1997) $Replace with [founditems] (1997) trouble updating records in database (1998) RAM problems, [appendfile] problems (1998) [WebDNA] Imagemagick (2018) Best way to add data to .db (1999) HELP WITH DATES (1997) using showpage and showcart commands (1996) [math] show=F exists? (1997)