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:

2.1 Stuff (1998) Protect (1997) wish list (2002) hidden (phantom) file downloads (2000) How can I record purchases to a database? (1998) Thanks for Encrypt.tpl - A Question (1999) Storebuilder Seems to have just died (2003) WebDNA Developer Resource Center (2002) WebCat2.0 [format thousands .0f] no go (1997) 2.0 Info (1997) [IpAddress] Tag (1997) Searching Groups for multiple matches (1998) JavaScript Image Problem (1998) Extended [ConvertChars] (1997) Unix Timestamp using WebDNA [code req] (2003) Frames and WebCat (1997) Help!!!! (1997) Search returns all, not 20 (1997) [OT] Adopting out a WebDNA website (2003) headers (2000)