Re: Date Sorting

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 13699
interpreted = N
texte = >Can anyone suggest where I'm going wrong on this date sort.>>I have a database with date information stored in the day/month/year format.>It is stored numerically ie 31/9/1997 and the field is called entrydate>>I want to sort the accompanying records in descending date order based on>their entry date into the system.>I'm using the following sort URL command :>>/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entr>y>datesdir=de&neUniqueIddata=0&max=15Your search parameter &datetype=Date should be &entrydatetype=Date ... :)Also, it's a lot safer to store your dates in the database in thedefault MM/DD/YYYY format, and then to change the format toDD/MM/YYYY if you want your users to see the dates in that format.Storing the dates in *other than* the default format may createproblems you would not have to deal with otherwise, so if mysuggestion regarding the search parameter doesn't work, it might beworth it to try changing your default date format back to the way itwas originally - MM/DD/YYYY. Yes, that means changing all yourexisting database records to reflect this format as well ...Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

Re: Date sorting ( charles kline 2004)
Re: Date sorting ( Tim Robinson 2004)
Re: Date sorting ( Jesse Proudman 2004)
Date sorting ( charles kline 2004)
Re: Date sorting (Kenneth Grome 2000)
Date sorting (Bj�rn Are Solstad 2000)
Re: Goofy Date Sorting (Michael Winston 1998)
Re: Goofy Date Sorting (Peter Ostry 1998)
Goofy Date Sorting (The Mooseman 1998)
Re: date sorting and 'template (Grant Hulbert 1997)
date sorting and 'template (Dan Keldsen 1997)
Re: Date Sorting (Kenneth Grome 1997)
Date Sorting (Tim Rignold 1997)
Re: Date sorting (Kenneth Grome 1997)
Re: Date sorting (Britt T. 1997)
Date sorting (Britt T. 1997)
Re: Date Sorting (Grant Hulbert 1997)
Re: Date Sorting (Glenn Davis 1997)
Re: Date Sorting (Grant Hulbert 1997)
Date Sorting (Glenn Davis 1997)

>Can anyone suggest where I'm going wrong on this date sort.>>I have a database with date information stored in the day/month/year format.>It is stored numerically ie 31/9/1997 and the field is called entrydate>>I want to sort the accompanying records in descending date order based on>their entry date into the system.>I'm using the following sort URL command :>>/SearchResults.tmpl$search?db=Classifieds.db&entrydatesort=1&datetype=Date&entr>y>datesdir=de&neUniqueIddata=0&max=15Your search parameter &datetype=Date should be &entrydatetype=Date ... :)Also, it's a lot safer to store your dates in the database in thedefault MM/DD/YYYY format, and then to change the format toDD/MM/YYYY if you want your users to see the dates in that format.Storing the dates in *other than* the default format may createproblems you would not have to deal with otherwise, so if mysuggestion regarding the search parameter doesn't work, it might beworth it to try changing your default date format back to the way itwas originally - MM/DD/YYYY. Yes, that means changing all yourexisting database records to reflect this format as well ...Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: Date Sorting

1997

Top Articles:

Related Readings: