Re: Formatting dates stored in db

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49283
interpreted = N
texte = Still problems:[format days_to_date %a][math]{[getchars start=5&end=6][orderdate][/getchars]/[getchars start=7&end=8][orderdate][/getchars]/[getchars start=1&end=4][orderdate][/getchars]}[/math][/format]Gives me Friday for today and Wednesday for yesterday?Am I doing something wrong?--Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com On Monday, April 7, 2003, at 04:00 PM, Donovan wrote:> WJ Starck wrote: > >> Ah, looks like I can do >> >> [format days_to_date %a]# of days since 00/00/0000[/format] > >> >> I see I can use [math] to convert a date to days since 00/00/0000. >> >> What's the best way to convert from my format (YYYYMMDD) to >> MM/DD/YYYY? > > I believe YYYYMMDD is a european format?? (some one correct me if I'm > wrong) > I don't know any other way to do this but text manipulation. > > [text]year=[getchars start=1&end=4][thedatefield][/getchars][/text] > [text]month=[getchars start=5&end=6][thedatefield][/getchars][/text] > [text]day=[getchars start=7][thedatefield][/getchars][/text] > > [text]newdate=[month]/[day]/[year][/text] > [text]dateasdays=[math][newdate][/math] > > > Donovan > >> >> >> -- >> ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Problem with formatting dates stored in db ( "Jesse Crofoot" 2003)
  2. Re: Problem with formatting dates stored in db ( Jay Van Vark 2003)
  3. Problem with formatting dates stored in db ( "Jesse Crofoot" 2003)
  4. Re: Formatting dates stored in db (Velma Kahn 2003)
  5. Re: Formatting dates stored in db (Rob 2003)
  6. Re: Formatting dates stored in db (WJ Starck 2003)
  7. Re: Formatting dates stored in db (WJ Starck 2003)
  8. Re: Formatting dates stored in db (Rob 2003)
  9. Re: Formatting dates stored in db (WJ Starck 2003)
  10. Re: Formatting dates stored in db (Matthew A Perosi 2003)
  11. Re: Formatting dates stored in db (Alex McCombie 2003)
  12. Re: Formatting dates stored in db (WJ Starck 2003)
  13. Re: Formatting dates stored in db (WJ Starck 2003)
  14. Re: Formatting dates stored in db (Donovan 2003)
  15. Re: Formatting dates stored in db (Alex McCombie 2003)
  16. Re: Formatting dates stored in db (Donovan 2003)
  17. Re: Formatting dates stored in db (WJ Starck 2003)
  18. Formatting dates stored in db (WJ Starck 2003)
Still problems:[format days_to_date %a][math]{[getchars start=5&end=6][orderdate][/getchars]/[getchars start=7&end=8][orderdate][/getchars]/[getchars start=1&end=4][orderdate][/getchars]}[/math][/format]Gives me Friday for today and Wednesday for yesterday?Am I doing something wrong?--Will Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.com On Monday, April 7, 2003, at 04:00 PM, Donovan wrote:> WJ Starck wrote: > >> Ah, looks like I can do >> >> [format days_to_date %a]# of days since 00/00/0000[/format] > >> >> I see I can use [math] to convert a date to days since 00/00/0000. >> >> What's the best way to convert from my format (YYYYMMDD) to >> MM/DD/YYYY? > > I believe YYYYMMDD is a european format?? (some one correct me if I'm > wrong) > I don't know any other way to do this but text manipulation. > > [text]year=[getchars start=1&end=4][thedatefield][/getchars][/text] > [text]month=[getchars start=5&end=6][thedatefield][/getchars][/text] > [text]day=[getchars start=7][thedatefield][/getchars][/text] > > [text]newdate=[month]/[day]/[year][/text] > [text]dateasdays=[math][newdate][/math] > > > Donovan > >> >> >> -- >> ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ WJ Starck

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:

3 card formulas! (1999) &FieldNametype=time unnecessary? (2000) switching users (1998) Re:Signal Raised (1997) How to sell events to customer and his guests?? (2005) BBedit wierdness upon opening "wide" database (2006) View order not right (1997) Add message to Order (1997) [/application] error? (1997) [WebDNA] writefile (2009) WebCat2.0 [format thousands .0f] no go (1997) Data Entry ... Excel Style ... How To? (2001) Pull Down Search (2000) RE: E-mail formating queston (1999) Extended [ConvertChars] (1997) More on the email templates (1997) New Mac Public Beta Available (1997) Design Help Needed (1998) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebCat2 - storing unformatted date data? (1997)