Hm, Based on your result it looks like you actually store the dates in a varchar field, don't. Modify the column type to date (or datetime if you need) and the query you have already written works correctly.
To test the usage of date datatype you can try running this:
SELECT MAX( CONVERT(DATE, DateOf_joining, 103) )
FROM Employee
That would convert your string to dates and get the maximum