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.
|