Re: sorting by date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23379
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:

[ModDate] bis_repetita (2000) Adding multiple items to Cart at one time, & append contextproblem (1998) Formulas.db + Users.db (1997) Chicago based WebCat Hosters (2000) New Command prefs ... (1997) RE: [WebDNA] ONLY the FIRST continuous run of numeric chars? (2008) Has anyone built this already? (2003) Help!!!! Purchases not going through! FIXED! (1997) POS (2000) default value from Lookup (was Grant, please help me) (1997) [shippingtotal] still... (2002) What's New Date (2002) $purchase WITHOUT creditcar (1997) webcat 3.06f on Linux keeps dying (1999) Help need to figure this out today!!! Advanced Question (2004) Can I invoke an ssi plugin from within a webcat page (1997) Finding unused SKU's in a database (2002) [WebDNA] Processing a CSV file for use as a db file (2016) How did *you* learn Web Catalog? (2000) WebCat virtual postcard is done! Thanks for the help! (1998)