[RESOLVED]Formatting using 'Date Added' Sort

Started by Wajo357, August 21, 2012, 06:53:32 PM

previous topic - next topic
Go Down

Wajo357

August 21, 2012, 06:53:32 PM Last Edit: August 21, 2012, 09:14:13 PM by shmax
http://shmax.com/View_Collection/1/853/?sort=date_added&page=1&sort_dir=1&num_results=100 
looks weird. The main headers show first Aug 19, 16, 17, back to 19... those are purchase dates, not dates added...
<a href="http://www.shmax.com/img/sigs/signature.swf?user_id=853" target="_blank" class="new_win">http://www.shmax.com/img/sigs/signature.swf?user_id=853</a>

shmax

Turns out I don't actually have "date added" data--I was simply sorting on the collect id, which is just an integer and has no date information to go with it. Whoops. I've added the field, so it will work fine going forward, but I don't know how come up with convincing dates for all the existing collection items. Just to have SOMEthing, I've copied the "date bought" dates over into the "date added" fields. It's kind of lame, but at least it will make the sort dividers do something.

So, I'll mark this one as resolved for now until someone can come up with some interesting plan for guessing more accurate dates for all those old collection items.

Wajo357

<a href="http://www.shmax.com/img/sigs/signature.swf?user_id=853" target="_blank" class="new_win">http://www.shmax.com/img/sigs/signature.swf?user_id=853</a>

Go Up