Thanks edwdecarlo, that works but only if the field has a column type set to Date. I created a new custom field to test it.
I import the date read directly from my Kindle and use a custom field set up like the attached. Unfortunately this doesn't get picked up
