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:

[returnraw] and form variables (1998) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Re:Running 2 two WebCatalog.acgi's (1996) WebMerchant Mac 3.0 beta available (1998) WebCat2b13MacPlugIn - More limits on [include] (1997) Many $WebCat.exe processes (1998) Re:WebCatalog f2 Installation (1997) Emailer (1997) Running 2 two WebCatalog.acgi's (1996) sort problems....bug or brain fart? (1997) dates as search criteria (2000) Replace Statement (1997) [isfile] ? (1997) WebCat2 several catalogs? (1997) logout after authenticated (2002) creative use of webcatalog (1998) WC2f3 (1997) Attn: Bug in GeneralStore example b15 (1997) Simple way to create unique SKU (1997) SetMIMEHeader Behaviour (2000)