Projects Schedule end date format

Hello,

How can I:

1. Format the "Schedule end" date to show as MM/DD/YY

2. Order records by "Schedule end" date (Newest to Oldest)

3. Group records by "Project Title"

2. Add a link to "Request ID" to allow direct access to that incident from that report

We use Service Desk Plus Build 9111 / MS SQL DB

The current query for this report is:

SELECT projectdet.TITLE "Project Title",

longtodate(projectdet.SCHEDULEDENDTIME) "Schedule end",

wo.WORKORDERID "Request ID",

wo.TITLE "Subject",

aau.FIRST_NAME "Requester",

ti.FIRST_NAME "Technician",

pd.PRIORITYNAME "Priority" FROM ProjectDetails projectdet

LEFT JOIN ProjectTypeDefinition projecttypedef ON projectdet.PROJECTTYPEID=projecttypedef.PROJECTTYPEID

Left join wotoprojects wot on projectdet.projectid=wot.projectid

left join workorder wo on wot.workorderid=wo.workorderid

LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID

LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID where projectowner.FIRST_NAME = 'Gabriela Tweten' AND projectstatus.STATUSNAME <>'Onhold' order by 1,3

Thanks