CDATE isn't a valid T-SQL function, it's ASP.
How is the ASP syntax structured?
Usually you'd do something like
strCMD = "SELECT dbo_CallLog.CallID AS Ticket, dbo_CallLog.Category, dbo_CallLog.CallDesc, dbo_Asgnmnt.Notes, " + CDate((dbo_Asgnmnt!DTLastMod/60/60/24)+25569)+
" AS LastMod, dbo_Asgnmnt.Assignee, dbo_Asgnmnt.Resolution " + ...
Or if you submit the variable to SQL, you'd need to do a CAST or CONVERT to reformat.