convert(datetime,CONVERT(NVARCHAR,TT.TDDATE,113),113)

SS.TRANSACTIONDATE

Most of the places used that date conversion so did you able to create extra column that have this converted value and use that column directly with using function.

add a...