Re: Changing Date Format in Field

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25402
interpreted = N
texte = Thanks Ken...I think I am almost there, but here's what I get:Here's my code:[format days_to_date %a, %b %d][math date]{[eventdate]}[/math][/format]Which works great at formatting...but now the dates are wrong. Now, all dates are either Sun, Jan 01 or Sun, Jan 02. This includes a range of about 15 dates which actually span Jan. 5 to Feb. 28 in reality. Any idea why my dates would be wrong?Timothy W. Killian --------------------------- wb: http://www.eventure.com ph: 206.559.2200 ---------------------------> From: Kenneth Grome > Reply-To: (WebCatalog Talk) > Date: Fri, 10 Dec 1999 14:27:59 -1000 > To: (WebCatalog Talk) > Subject: Re: Changing Date Format in Field > >> Hi All: >> >> I have a field in a database called eventdate which contains the date of >> an event. Currently, I have a search that sorts by date, and all works >> great. However, I want to format the eventdate to be like Wed, Feb. 2 >> even though my global pref is mm/dd/yyyy. I know I can overide the format of >> the [date] tage by adding the modifiers, but can I do this to a field that >> contains date information? How? > > First, turn the date into the number of days since 0000 by using the math > context, then change that number to the proper date format by using the format > context. > > ================================ > Kenneth Grome, WebDNA Consultant > 808-737-6499, http://webdna.net > ================================ > > > > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go 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:

    
  1. Re: Changing Date Format in Field (Kenneth Grome 1999)
  2. Re: Changing Date Format in Field (Timothy W. Killian 1999)
  3. Re: Changing Date Format in Field (Kenneth Grome 1999)
  4. Changing Date Format in Field (Timothy W. Killian 1999)
Thanks Ken...I think I am almost there, but here's what I get:Here's my code:[format days_to_date %a, %b %d][math date]{[eventdate]}[/math][/format]Which works great at formatting...but now the dates are wrong. Now, all dates are either Sun, Jan 01 or Sun, Jan 02. This includes a range of about 15 dates which actually span Jan. 5 to Feb. 28 in reality. Any idea why my dates would be wrong?Timothy W. Killian --------------------------- wb: http://www.eventure.com ph: 206.559.2200 ---------------------------> From: Kenneth Grome > Reply-To: (WebCatalog Talk) > Date: Fri, 10 Dec 1999 14:27:59 -1000 > To: (WebCatalog Talk) > Subject: Re: Changing Date Format in Field > >> Hi All: >> >> I have a field in a database called eventdate which contains the date of >> an event. Currently, I have a search that sorts by date, and all works >> great. However, I want to format the eventdate to be like Wed, Feb. 2 >> even though my global pref is mm/dd/yyyy. I know I can overide the format of >> the [date] tage by adding the modifiers, but can I do this to a field that >> contains date information? How? > > First, turn the date into the number of days since 0000 by using the math > context, then change that number to the proper date format by using the format > context. > > ================================ > Kenneth Grome, WebDNA Consultant > 808-737-6499, http://webdna.net > ================================ > > > > > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go 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 > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go 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 Timothy W. Killian

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:

NEW INFO: I'm stuck: Can't open order file.Ignoring[OrderFile] context (2000) writing orders to a db (1997) Replace context problem ... (1997) possible, WebCat2.0 and checkboxes-restated (1997) WC1.6 to WC2 date formatting (1997) Logging purchases (1997) GuestBook example (1997) Problem: 3.0 doesn't update carts (1997) WebCommerce: Folder organization ? (1997) WebDelivery downloads alias, not original ? (1997) Formating found categories (1997) emailer (1997) formulas.db ?? (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) restart needed???? (1997) Banner Ad Server Solutions Using WEbDNA (2000) hideif [x]=1,2,3.. (2003) [WebDNA] XML Help (2009) Dubble Sku's in a Database (1999) NewCart+Search with one click ? (1997)