createdate = "CONVERT(datetime, CONVERT(varCHAR(4), DATEPART(year, C.C_CreateDate
)) + '-' + CONVERT(varCHAR(2), DATEPART(month, C.C_CreateDate)) + '-' + CONVERT(v
arCHAR(2), DATEPART(day, C.C_CreateDate)))"
CTDate = "CONVERT(datetime, CONVERT(varCHAR(4), DATEPART(year, C.C_T_Date)) + '-'
 + CONVERT(varCHAR(2), DATEPART(month, C.C_T_Date)) + '-' + CONVERT(varCHAR(2), D
ATEPART(day, C.C_T_Date)))"