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 you are in Germany and I am not sure if the the [date] object interprets it differently there or not. In the US Month/DayofMonth/Year is the common format, is yours DayofMonth/Month/Year? is there a preference somewhere that could be tripping this up (webcat thinks it's looking at one thing but its an 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:
sounds like the date set on your server could be wrong. but then again you are in Germany and I am not sure if the the [date] object interprets it differently there or not. In the US Month/DayofMonth/Year is the common format, is yours DayofMonth/Month/Year? is there a preference somewhere that could be tripping this up (webcat thinks it's looking at one thing but its an 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:
Searchable WebCat (etc.) Docs ? (1997)
Nesting WebDNA in JavaScript (2003)
WebCatalog2 Feature Feedback (1996)
[WebDNA] Filtering exact numbers (2008)
Cookies and webcat (1997)
WC2b15 File Corruption (1997)
Form based Redirect (2001)
[WebDNA] It's been a while so ... (2009)
Bug or syntax error on my part? (1997)
webcat2b12 CGI -- Date comparisons (1997)
Document Contains No Data! (1997)
Help me choose an upgrade path to 5.0 (2003)
sorting by date (1999)
WebCat & Liststar ... & Rumpus, too! (1997)
Re:E-mailer application times out (1998)
Migrating to NT (1997)
if/then/else question - nevermind, my stupidity... (2000)
WebCat2.0 [format thousands .0f] no go (1997)
[CART] inside a [LOOP] (1997)
NetForms for mail, sorry (1998)