Re: sorting by date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23378
interpreted = N
texte = >I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98 > >etc. > >Do I need to convert this date structure to something else first in order to >do this right???Yes, the dateformat pref must match the date format in your db fields.Sincerely, Ken Grome Associated Messages, from the most recent to the oldest:

    
  1. Re: sorting by date Y2K mix up (Brian B. Burton 2000)
  2. Re: sorting by date Y2K mix up (Kenneth Grome 2000)
  3. sorting by date Y2K mix up (Laurent Pladys 2000)
  4. Re: sorting by date (PCS Technical Support 1999)
  5. Re: sorting by date (Kenneth Grome 1999)
  6. Re: sorting by date (Kenneth Grome 1999)
  7. sorting by date (Richard 1999)
  8. Re: Sorting by date (Trevor Crist 1997)
  9. Re: Sorting by date (Trevor Crist 1997)
  10. Re: Sorting by date (Trevor Crist 1997)
  11. Re: Sorting by date (marty@artwerks.com (Marty Schmid) 1997)
  12. Re: Sorting by date (Grant Hulbert 1997)
  13. Re: Sorting by date (Marty Schmid 1997)
  14. Sorting by date (Trevor Crist 1997)
  15. Re: Sorting by date (Grant Hulbert 1997)
>I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98 > >etc. > >Do I need to convert this date structure to something else first in order to >do this right???Yes, the dateformat pref must match the date format in your db fields.Sincerely, Ken Grome Kenneth Grome

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:

carriage returns in data (1997) Many $WebCat.exe processes (1998) Bug Report, maybe (1997) More DateMath problems (1997) [WebDNA] Query re: autonumber (2010) Sorting problem (1997) sendmail formatting (2001) This message couldn't reach the list! (1998) FW: Shipping calculations (1997) More on the email templates (1997) [TaxableTotal] - not working with AOL and IE (1997) Safari browser and WebDNA set-cookies (2003) [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020) Applescript error (1998) Replace context problem ... (1997) PIXO support (1997) Version f1 status (1997) Variable Prices (1998) Quit revisited (1997) Access and WebDNA (2002)