MobileRead Forums - View Single Post - Method to set Date from user integer column

macnab69 · 07-06-2013, 10:55 AM

I have listed (I don't have them all yet) Agatha Christie's books. I have entries in Series for the Hercule Poirot stories, the Miss Marple stories, etc.

But I want to be able to list them in order of date written. I currently have an integer user column (called Agatha Sort) to put them in the correct order. I would like to use the Date column instead. (For these books I am not interested in the date I added them.)

Is there a way I can transfer the user column to the Date column so that when sorted according to Agatha Sort, Date reads 1 Jan 2000, 2 Jan 2000, 3 Jan 2000, etc.?

Agatha Sort currently has 01, 02, 03, etc.

It seems a waste to have a column dedicated to just one author.

07-06-2013, 10:55 AM	#1
macnab69 Zealot Posts: 129 Karma: 5754 Join Date: Jan 2012 Location: South Africa Device: Kindle 4	Method to set Date from user integer column I have listed (I don't have them all yet) Agatha Christie's books. I have entries in Series for the Hercule Poirot stories, the Miss Marple stories, etc. But I want to be able to list them in order of date written. I currently have an integer user column (called Agatha Sort) to put them in the correct order. I would like to use the Date column instead. (For these books I am not interested in the date I added them.) Is there a way I can transfer the user column to the Date column so that when sorted according to Agatha Sort, Date reads 1 Jan 2000, 2 Jan 2000, 3 Jan 2000, etc.? Agatha Sort currently has 01, 02, 03, etc. It seems a waste to have a column dedicated to just one author.