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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>> 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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)