Tuesday, November 29, 2011

Excel function to convert date "2011-11-04-23.22.10.446908" to "2011-11-04"

=MID(A2,SEARCH("2011",A2,1),10)

No comments: