Forum Discussion
kpan8
Jan 21, 2025Copper Contributor
Questions about converting date
I used a function to convert character to date and then do a calculation using datediff. ,CONVERT(DATETIME,CONVERT(CHAR,cs.LastCourseActivityDate)) AS Last_Course_Activity_Datetime ,case ...
rodgerkong
Feb 07, 2025Iron Contributor
when m.CompletionStatusYear = 2024 then '2024-21-31 00:00:00.000
It should be '2024-12-31 00:00:00.000'