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:

embedding [showcart] ??? (1998) bug ? causes NT event log to fill (1997) Searchable WebCat (etc.) Docs ? (1997) Configuring E-mail (1997) Limit on nested [ShowIf]'s? (1997) (1997) WebCat2 beta 11 - new prefs ... (1997) ShowIf variables (1997) Re:Copyright ? (1997) New WebCatalog Version !!! (1997) [isfile] ? (1997) Help! WebCat2 bug (1997) We have Proof (1997) RequiredFields notes ... (1997) WebCat2_Mac RETURNs in .db (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Fulfillment e-mail? (1998) Bad Cookie / Internet Option / Internet Explorer (2004) Help!!!! (1997) Cookies and webcat (1997)