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:

[ot] html question (2000) When to Commitdatabase? (2004) WebCat2 - [format thousands] (1997) World Address Info (2003) Robert Minor duplicate mail (1997) Finding max value for a field (1997) Apoligy (1997) Fwd: Problem with order (1998) ListWords passing multi values in one form field (2000) [WebDNA] Talk archives (2010) [OT] Missing access_log (2003) Multiple SSL Keys (1998) Getting total number of items ordered (1997) New Web Site Developers Database (1996) To Do list (2003) sorry (1997) emailer (1997) Sendmail (SMTP) coming from smithmicro.com (2002) Package Prices (2000) RE: Re:Signal Raised (1997)