Re: Goofy Date Sorting

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20444
interpreted = N
texte = At 10:00 Uhr 14.10.1998, The Mooseman wrote:>Anyone know how I can get >desending from oldest date to newest date in mm/dd/yy order?General recommendation: Store dates in databases as numbers, not as date values! [Math]{4/7/1997}[/Math] stores the date as number of days from 0/0/00, sorting and searching will work correctly and with [Format Days_To_Date] you get your date expression back.Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Associated Messages, from the most recent to the oldest:

    
  1. Re: Goofy Date Sorting (Michael Winston 1998)
  2. Re: Goofy Date Sorting (Peter Ostry 1998)
  3. Goofy Date Sorting (The Mooseman 1998)
At 10:00 Uhr 14.10.1998, The Mooseman wrote:>Anyone know how I can get >desending from oldest date to newest date in mm/dd/yy order?General recommendation: Store dates in databases as numbers, not as date values! [math]{4/7/1997}[/Math] stores the date as number of days from 0/0/00, sorting and searching will work correctly and with [Format Days_To_Date] you get your date expression back.Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Peter Ostry

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:

Modulo function? (2000) help (2001) Test (2003) Database Changes (2000) [dos] command question (1997) First postarg not taking in $Commands (1997) error message (2000) The List is Changing (1997) SSL and Webcat (2000) New command suggestion (1997) [OT] QuickDNS (2007) Displaying Location (1997) [WebDNA] Privat IP website behind a public IP website (2014) Intranet Edition (2003) Best way to handle 404 errors with WebDNA and Web* V (2003) Limit to Field Length in DB (1998) MacOS alias identification? (1998) Forum - Test Request (2005) WC2f3 (1997) [WebDNA] Alt Web Servers OS X (2011)