Date Sorting

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13698
interpreted = N
texte = Can anyone suggest where I'm going wrong on this date sort.I have a database with date information stored in the day/month/year format. It is stored numerically ie 31/9/1997 and the field is called entrydateI want to sort the accompanying records in descending date order based on their entry date into the system. I'm using the following sort URL command :/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entry datesdir=de&neUniqueIddata=0&max=15This sort appeared to list the entries the way I wanted, until the end of this month. It now sorts all of September in the correct order (Top of page 30/9/1997 and 1/9/1997 at the bottom) but it then places the 1/10/1997 entries at the very foot of the and list not at the top.I'd appreciate any advice on how to get this to sort correctly.Kind regards, Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 9111 80 Berry Street Facsimile + 61 7 3839 5442 Spring Hill Queensland email tim@webhost.com.au AUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE 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)
Can anyone suggest where I'm going wrong on this date sort.I have a database with date information stored in the day/month/year format. It is stored numerically ie 31/9/1997 and the field is called entrydateI want to sort the accompanying records in descending date order based on their entry date into the system. I'm using the following sort URL command :/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entry datesdir=de&neUniqueIddata=0&max=15This sort appeared to list the entries the way I wanted, until the end of this month. It now sorts all of September in the correct order (Top of page 30/9/1997 and 1/9/1997 at the bottom) but it then places the 1/10/1997 entries at the very foot of the and list not at the top.I'd appreciate any advice on how to get this to sort correctly.Kind regards, Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 9111 80 Berry Street Facsimile + 61 7 3839 5442 Spring Hill Queensland email tim@webhost.com.au AUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE Tim Rignold

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:

PSC recommends what date format yr 2000??? (1997) OT: Google (2002) Reverse WHOIS (2003) Searching multiple fields from one form field (1997) WCf2 and nested tags (1997) weird happenings (1997) no template caching (1997) Help! WebCat2 bug (1997) WebDNA 6 (2004) webcat- multiple selection in input field (1997) WebCat editing, SiteGuard & SiteEdit (1997) WC 2.0 frames feature (1997) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) WebCat2.0 [format thousands .0f] no go (1997) unique ascending numbers (2003) WebCatalog can't find database (1997) The beginning (1997) Change Subtotal (2000) WebCat2 Append problem (B14Macacgi) (1997) Keep away (1997)