[ic] Sorting by date

[John Allman]

Paul Jordan wrote:
>>Hi - i'm something of a newbie here so this might be a stupid question.
>>
>>I have a mysql database and am about to add a new table (or tables) to
>>add news content to the website. The important thing is that i want to
>>be able to sort news items by date.
>>
>>i know this is a basic problem but the undoubtedly simple solution is
>>eluding me. if i store the date as a string with things like Jan and Feb
>>in it and i sort alphabetically i wont get the results i want.
>>
>>i could store each value numerically and sort by year then month then
>>day of the month then time but this seems an ugly way to go about it.
>>
>>I am running interchange 4.6.5.
>>
>>thanks in advance!
>>
>>John Allman
> 
> 
> 
> No, that is the best way. yyyymmdd is the way to go, then use [convert-date]
> 
> http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=ictags06%2e03
> 
> 
> 
> 
> or the [time] tag
> 
> http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=ictags04%2e75
> 
> 
> HTH
> 
> Paul
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

Perfect - this is exactly what i was hoping for. thanks guys!

John