Re: Date Sorting

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12425
interpreted = N
texte = >Dates are stored in a db in the format mm dd. I'll try adding to >geEventData=Jan 01 and see if that does it. I did not use the year in the >date, because it just didn't seem important.That won't work. WebCatalog is not psychic -- it has no idea what Jan 01 means, so it treats it like a simple string of letters. So it will get alphabetized as text, and that means Feb comes before Jan.It does know what 12/7/1997 means, though, because that is a supported date format.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Date sorting ( charles kline 2004)
  2. Re: Date sorting ( Tim Robinson 2004)
  3. Re: Date sorting ( Jesse Proudman 2004)
  4. Date sorting ( charles kline 2004)
  5. Re: Date sorting (Kenneth Grome 2000)
  6. Date sorting (Bjørn Are Solstad 2000)
  7. Re: Goofy Date Sorting (Michael Winston 1998)
  8. Re: Goofy Date Sorting (Peter Ostry 1998)
  9. Goofy Date Sorting (The Mooseman 1998)
  10. Re: date sorting and 'template (Grant Hulbert 1997)
  11. date sorting and 'template (Dan Keldsen 1997)
  12. Re: Date Sorting (Kenneth Grome 1997)
  13. Date Sorting (Tim Rignold 1997)
  14. Re: Date sorting (Kenneth Grome 1997)
  15. Re: Date sorting (Britt T. 1997)
  16. Date sorting (Britt T. 1997)
  17. Re: Date Sorting (Grant Hulbert 1997)
  18. Re: Date Sorting (Glenn Davis 1997)
  19. Re: Date Sorting (Grant Hulbert 1997)
  20. Date Sorting (Glenn Davis 1997)
>Dates are stored in a db in the format mm dd. I'll try adding to >geEventData=Jan 01 and see if that does it. I did not use the year in the >date, because it just didn't seem important.That won't work. WebCatalog is not psychic -- it has no idea what Jan 01 means, so it treats it like a simple string of letters. So it will get alphabetized as text, and that means Feb comes before Jan.It does know what 12/7/1997 means, though, because that is a supported date format.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

WebCat 5 Intranet Question (2003) MetaKW tags from databases (2006) Location of Webcat site in folder hierarchy (1997) Max Record length restated as maybe bug (1997) Multiple Carts with Mac IE (2002) trouble updating records in database (1998) [WebDNA] Friday's.. WIP thread (2009) SSL problems (2002) [WebDNA] sort parameters in search (2015) Comments in db? (1997) hiding return characters (2000) WebCat2 beta 11 - new prefs ... (1997) functions... (2005) underscore in variable name (2000) synching databases on multiple servers (1997) WebCat/CyberStudio Compatibility (1998) Checking for pre-existing passwords (1998) Can I invoke an ssi plugin from within a webcat page (1997) Forumulas.db & Variables (2002) Great product and great job ! (1997)