I know MSSQL but seems that mySQL is not liking some syntax I need help with the Date Add Function here is the query below what am I doing wrong with the the DateADD fucntion in this syntax?
SELECTagentactivity.AgentFirstName,agentactivity.AgentLastName,Count(call.WorkgroupCall) AS TotalCalls,agentactivity.WorkgroupName,call.DialedNumberFROM`agentactivity`Inner Join `queuecall` ON agentactivity.QueueCallID = queuecall.IDInner Join `connect` ON queuecall.ConnectTableID = connect.IDInner Join `call` ON call.ID = connect.CallTableIDInner Join `calltype` ON call.CallType = calltype.CallTypeWHEREcall.StartTime < DATE_ADD(day, -10, NOW())GROUP BYagentactivity.AgentFirstName,agentactivity.AgentLastNameORDER BYTotalCalls DESC
Sweet, I looked at the online document prior to my asking the question, seems I was just missing the "Interval" key word, good to know about the shortcut.
Thank you for the Fast Reply!
Thank you for the Fast Reply!