select max(convert(char(12), Modified_Date, 101))
from databasename..Metrics