Am using the below SQL query to fetch the trqansfer ticket details but Iw ant the details for the particular time period(for jan 2014 to dec 2014) how to achieve this using time stamp,
can we get the ticket details using open date and close date also,please advise.
From act_log ,
where act_log.call_req_id = call_req.persid
AND act_log.description LIKE('%Transfer Group from ''SRC'' to ''ESR_EMAAP''%')