从MS-SQL Server查询转换为MySQL和DATEDIFF（）

I have been convering the following MS-SQL Server's query to MySQL and I am stuck at this date part. Can anyone please tell me what I am doing wrong here? I have been convering the following MS-SQL Serv