Re: Dates - Search and Sorting

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23032
interpreted = N
texte = >> 1- Quit WebSTAR and WebCatalog. >> 2- Open the WebCatalog Prefs file with SimpleText. >> 3- Set these two prefs as follows: >> >> DateFormat%d/%m/%Y >> ReadDateFormatdmy >> >> 4- Save and close the WebCatalog Prefs file. >> 5- Restart WebSTAR. >> 6- Try your search again. > >Okay, preferences modified as above... > >It did affect the sorting to make the above change, though it still didn't >sort the way I expected it wouldYou may want to think about getting rid of all the formatted dates in your databases, and instead, store your dates as the number of days since 0000 by using [math]{[date]}[/math] instead of [date] in your append and replace contexts.Then you never have to worry about this stuff anymore, because the dates will sort properly, and you can display them in your web pages in whatever format you want simply by using [format days_to_date][datefield][/format]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  2. Re: Dates - Search and Sorting (Mike_Davis 1999)
  3. Re: Dates - Search and Sorting (PCS Technical Support 1999)
  4. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  5. Re: Dates - Search and Sorting (RH Prouty 1999)
  6. Re: Dates - Search and Sorting (RH Prouty 1999)
  7. Re: Dates - Search and Sorting (RH Prouty 1999)
  8. Re: Dates - Search and Sorting (Howard Wolosky 1999)
  9. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  10. Re: Dates - Search and Sorting (RH Prouty 1999)
  11. Re: Dates - Search and Sorting (RH Prouty 1999)
  12. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  13. Dates - Search and Sorting (RH Prouty 1999)
>> 1- Quit WebSTAR and WebCatalog. >> 2- Open the WebCatalog Prefs file with SimpleText. >> 3- Set these two prefs as follows: >> >> DateFormat%d/%m/%Y >> ReadDateFormatdmy >> >> 4- Save and close the WebCatalog Prefs file. >> 5- Restart WebSTAR. >> 6- Try your search again. > >Okay, preferences modified as above... > >It did affect the sorting to make the above change, though it still didn't >sort the way I expected it wouldYou may want to think about getting rid of all the formatted dates in your databases, and instead, store your dates as the number of days since 0000 by using [math]{[date]}[/math] instead of [date] in your append and replace contexts.Then you never have to worry about this stuff anymore, because the dates will sort properly, and you can display them in your web pages in whatever format you want simply by using [format days_to_date][datefield][/format]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

Blocking off access (2005) Email Problem (2006) problem with [include] and Web*/SSL 3.0.1 (1998) how do I have html files routed through webcat on OSX? (2001) OT: Version Control (2007) Tool of Use to Unix WebCat Admins (2000) WEBCAT with SQL backend. Help please! (2000) New command suggestion (was Modifying databases manually) (1997) SET (1998) InSecureTextVariables.... (2000) [isfolder] and [filename] (1997) Signal Raised (1997) [WebDNA] Lookup inside grep?... (2011) WebCat2 beta 11 - new prefs ... (1997) Help! WebCat2 bug (1997) Emailer (1997) A zip code search (1998) WebDNA 5 & iTools 7 (2003) Can someone remove this guy with the 186k emails!? (Thanks for the email!) (1998) [WebDNA] why is the webdna.us site slow? (sometimes?) (2011)