Had something similar before and I am sure that I had to convert it to Number and then convert that to date.
It seemed pretty daft at the time but worked from memory
It was in my old job and that was 2 years ago so I may have just got one of the bods to do it for me as they would get...