strange bug on query reminder

Hi o all, i have a strange error from suitecrm.log for the query reminder:


Query Failed: SELECT  reminders.*  , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner  , N'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner  , N'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner  , N'Users' assigned_user_name_mod FROM reminders   LEFT JOIN  users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0  LEFT JOIN  users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0  LEFT JOIN  users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

 AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute BETWEEN CONVERT(datetime,N'2019-02-05 10:39:29',120) AND CONVERT(datetime,N'2019-02-06 11:39:29',120))) AND reminders.deleted=0::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Arithmetic overflow error converting expression to data type datetime.

Any suggest? my suite version in 7.10.7

That sounds like a SQL Server peculiarity. I just say this because I believe that code works well in other databases.

Maybe open an issue on Github? Better if you can provide a fix, I found some pages on StackOverflow saying it is all a matter of casting to string first, or using strings instead of numerics in the first place.