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:
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)